how about this, I am trying to break this down to simple pieces
single form with data1 and dbgrid1
using a command button with the following code:
Code:
Private Sub Command1_Click()
Data1.RecordSource = "Table2"
Data1.Refresh
DBGrid1.Refresh
End Sub
I was hoping to get the data grid to stop showing the info in table1 and start showing the info in table2
I don't get an error but I dont see the infomation that table2 contains.

What am I doing wrong?
thank you for your time and have a good day