Hi. Am trying to search to seperate Access fields from VB but the code I am attempting:
Foo5 = Combo1.Text
Data1.RecordSource = "Select * from Details1 where region = '" & Foo5 & "' and reps ='1'"
Combo1.Text = "select"
Does the search have to be done using two seperate lines or perhaps my code gramatics is wrong.