Multiple Form / Data access

[richself]

This is really confusing me. I have a project with 2 forms. Form1 and Form2. I'm calling the second form from the first one by:

Dim myForm2 As New Form2
myForm2.Show()

That code is in a button click, the second form comes up fine from there. The problem is when I try to update a table in Access. I've put a DataGrid on the form to watch the Dataset and I add the new row and populate what needs to be done but when I try to update it won't change the Access file. I have used virtually the same code that's on the first form. I have no issues when working on the first form.
What am I doing wrong? Any help would be appreciated. I've created all new command, connection, adapter and dataset on the second form.

 

[chiph]

Google on Model-View-Controller architecture.

In this design pattern, most of your code is moved into another class (the "controller" part), and your forms only then are concerned with the presentation of the data.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first