Dlookup

[melisc]

I am creating a database for a vendor and I am trying to get one field on a form to lookup a value from a table. The other fields already run on macros and are just used to populate dollar amounts. I need the county ID to populate automatically based on the Vendor name. Does anyone know the correct command or procedure for this command to run?

Thanks.

 

[scousethemoose]

I think this example may help it uses the DLookup function. Just change the table and field names to suit you.

varcountyID = DLookup("countyID", "tblVendors", "vendorName ='" & [vendorName] & "'&quot

countyID.text = varcountyID

You would put this in the on update section of the field containing the vendor name.

Hope it helps

 

[melisc]

Thanks a bunch for the help. This is the command that I wrote:


=DLookUp("countyID","locations","location ID ='" & [Location ID] & "'&quot


It is returning an error to me.

It is a form that is linked to query. The [Location ID] is the field that is populated with the Vendor name and the [County Id] is the field that I want to self populate based on the data in the[LocationID] field. The table that I need it to lookup from is named [locations]

Does it make a difference if I am looking by the ID associated with the name? The combo box has the Location ID and the Location Name although I hid the Location ID so that there was no confusion. I am also trying to lookup by Table even though the form runs off of a query, is that OK?

Thanks again for your help!