Linking records to auto complete information

E

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!!
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto populate value from one task to another in MS PROJECT 0
Auto Populate One Pages from spreadsheet 0
Auto Merge text from multiple sources 0
Quotation Mark preferences missing 0
Automatically sending multiple parts of text from one word doc to another - is possible. 0
Weighted % Complete calculation 1
Integrating information from Word to Excel (not mail merge) 1
outlook auto complete problem 2

Top