I am hving problem with below code:
If cboequipnum.Text = "Equipment 1" And cbomeslotnum.text = "A1" Then
Data1.RecordSource = "select * from main table where Meslot = 'A1' And Equipment# = 'Equipment1' "
main table is table in access db, and meslot and equipment# are fields of main table
I think I have the "select * "syntax wrong, as I get an some sort of date error when I try to excecute this code...If I remove the last line of the above code it will work. Adding the and statement seems to throw it off.