Form for Data Entry

[Glenn]

I am using a Form for data entry into one table and would
like to use the available data in another table an an auto
fill. The data entry table has many fields, 2 of which
are BranchID and BranchName. There is a table that holds
a list of only the BranchIDs and BranchNames. I would
like the data entry form to look for the BranchName once I
have entered a BranchID. Grateful for some help, I have
not been able to make the DLookup examples within Access
2000 work as either a ControlSource or an EventProcedure.

 

[Dan Artuso]

Hi,
If you already have a table that contains BranchId and BranchName, then you only want
to enter BranchId into your other table. You would have a combo box to do this.
The RowSource for the combo would be a query similiar to:

Select BranchId,BranchName From tblBranches Order By BranchName

You would set the combo box properties:

Columns: 2
Column Widths: 0";1"
BoundColumn: 1

and set the Control Source to the BranchId field of your data entry table

Now your combo will display the BranchName but it will save the BranchId to your data entery table.