Linking records to auto complete information

[Emma]

Hi,

It's been a while since I used Access 2003, and I am having trouble finding
out how to auto complete information in forms! I have a contact, quotes and
orders database, and each record has a unique contact ID, qoute ID and order
ID. I would like to enter the quote ID in the orders form page, so they are
linked together, and the information from the quote page is used to complete
the order information. I have set up links between these tables for the
quote ID.

Any help would be gratefully received!!

 

[GBA]

* make your query that links these tables together

* make a form that is sourced on this query

* add a combobox to the header of the form; in the combo wizard during set
up - be sure to select the option of 'find a record based on this
selection'...and set your combo box to look at the same query and involve
only those fields you consider needed by the user to make a selection