Search results

the syntax will be wrong but I am sure you can see what I want to achieve. Some help with the syntax will be much appreciated Private Sub ClientId_AfterUpdate() Dim varName As Variant // to store the results Dim sqlstr As String ' Check if combo box is null If...

Yes, that's the syntax, but how do I get the results into varName?

The snipet below returns only a single record. I want all the records. I am not sure how to get the results from the query or the syntax. This is what I want: Select location from client_loc where clientID = FORMS!job.ClientId Thanks --------------------------------- Private Sub...

Hi, I have two combo boxes where the first lists values in one table. On selecting one I want a second combo populated with records in another table where foreign key = primary key. Obviously the query is select location from client,location where client.client = location.client However I...