Form for Data Entry

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Glenn - 09 Jan 2005 16:43 GMT

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.

Reply to this Message

Dan Artuso - 09 Jan 2005 17:27 GMT

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.

--
HTH
Dan Artuso, Access MVP

> 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
[quoted text clipped - 5 lines]
> not been able to make the DLookup examples within Access
> 2000 work as either a ControlSource or an EventProcedure.

Reply to this Message