Thread: Using Combobox value in ADO Query.

I'm getting the error below when I'm trying to use a Combobox Value in my access query. I've done this in design view. In the criteria field in the referenced column in my query I've placed the below filter. The idea is that when I change the combobox the event triggers a procedure which calls the query. That query incorporates the value from Combobox50. I've also placed the code below as well.

Not sure if my syntax is wrong. Can anybody help. Thanks

[forms]![form1]![combo2] 'have placed this in criteria field


Error below.
'Invalid SQL Statement; Expected Delete, Insert, Procedure, select or Update'

Private Sub Combo2_AfterUpdate()
Dim rst1 As Recordset


Set rst1 = New ADODB.Recordset

rst1.Open "RefLookup", CurrentProject.Connection ' "RefLookup" is the query name.

Form_Form1.Text37.Value = rst1.Fields(1)

End Sub

What happens when you run the query manually? Here is a video on creating a search form linked to a query. Does this help you?

http://www.datapigtechnologies.com/f...earchform.html

Alan

Are you able to post your db with some sample data so that we can look at it and see what the issues are.

Alan

No worries.

I've attached an example. All you do is select the car type in the combobox and it should give you the colour in the textbox. Though I get the error.

thanks in advance.
Danny2000

Danny,
I have changed your form as attached in the database. I deleted your after update event and made your control source for the car-make a query. Look at the properties for the two form controls. There was no need for any VBA to make this work. You can delete the query you have as it is not needed.

Alan