Query does not display form data (1 Viewer)

Hi All,

Pls could you assist? I have a form where I select a customer from a drop down.
My second control only displays records relating to the dropdown in the first control.
All works fine.
I have added a query that filters from the first control.
In the query, I want to display only records that equal the record selected in the form, same as in the second control, but this time my query remains blank.
The control in the form is in focus.
Any Ideas?

What is the query ? You've not given us a lot to go on I'm afraid.

Form names etc. will also assist.

On my edit history form, I select the customer from dropdown
second dropdown only shows record which are related to the customer selected.
that all works just fine.
now I want a query to give me history record from only the customer which has been selected. the query result is blank. as if the customer dropdown value is not stored to be used again but still in the second drop down it works just fine

My guess would be the Criteria of CustomerID in the Query. Forms!......!CustomerID

Provided the query will open after the form has been updated. Else you need to use VBA after updating the combo.

docmd.openquery "......."
docmd.requery