Combobox Selection To Run Query

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

Alan

Thats something like I'm looking for, what I need is that when I click on the combobox and select a job number it will run the query and populate the text boxes on the form with the relevant data in the query. What the tutorial is doing is running a query based on something I would have to type into a parameter box and it is opening a table not populating the textboxes.

Any suggestions or other tutorials would be appreciated

Alan

Thats pretty close to what I am looking for. So I can take data from multiple tables link them to each other and put into the query to display on the form is that correct

Ok

Got it working my only problem is now in the combobox it's only showing 1 record when there are 3 in the table. Any idea why it was showing the others before

form is in Form View

Yes it shows 4 records but when i click each record the form is blank other than the one record I can see