Thread: Building a Form that references a table

Just inherited an Access Database that tracks member activity...

Two main tables
1. Transactions
2. Dealer List (dealer code, name, contact info, etc)

Currently users enter directly in the transaction table... causing major accuracy issues. I have created a Form for them to enter transaction information (mbr name, dates, amount, etc.)

The problem... I want to have a field for Dealer Name but need the list to match what is currently in the Dealer List table.

How do reference a table in a Form? List, combo list?

If you ant to crreate a combobox that shows the list of the dealers then

1. Create a combo box

2. Display property sheet

3. In row source table select Table / query

4. In row source click the drop down arrow and select the required
table (may be dealer in this case)

5. Use control source property to set the destination if data (where to
save).

An automatic wizard may run when you create the combo box. follow this

Regards

The combobox worded perfectly... Thanks!

In looking at my new form I see some areas where I can improve the process.

?. How do I look up a value in another table? I've tried DLookup but cannot get it to work.

Two main tables
1. Transactions
2. Dealer List (dealer code, name, contact info, etc)

I have a combo box to select Dealer Name in my transaction form. I would like to pick a Dealer from the list and have the Code Field populate automatically.

Ex: select Dealer - James Johnson.... Lookup in Dealer List and populate code JJ