Need help with auto fill in a form

[darrrellx]

I am a new access user and need some help. I have created an auto fill query to fill in information on a sales order table from my customer table based on CustomerID.

I have also created a sales order form. When I enter the customer ID in the form the rest of the data does not fill in. Actually nothing happens.

How do I link the form to the query so that the form knows where or how to look for the auto fill customer data.

Thanks

Darrell R

 

[trucktime]

Form

Have you specified the data source for the form?

Parhaps you can post the db (without sensitive data) so someone can have a look.