Hi

Can anyone tell me how I can achieve the following in simple steps.

I have a form that will show static data in textboxes that are in the form detail and form header based on the selection of a job number in a combobox that is in the form footer.

The data has to come from 2 different tables. I assume I have to create a query based on the data i want from each table. How do I link the combobox selection to the query criteria: so that it only returns the data for that job number and once that is done how do I get it to display in the form textboxes.I know how to get the combobox to populate the textboxes with data from one table.

Any help would be much appreciated