Lookup Field Automatically Updated from Another Lookup ? ? ?

  • Thread starter Thread starter Dodge Brown
  • Start date Start date
D

Dodge Brown

Hi All


Basically I have a Subform Which has 2 fields of interest here, The First
'Product ID' and the Second 'Product Description' held in the same table.

These fields are supplied with their lookup data from another table called
'Products'.

I would like it so the user is able to select either 'ID' or 'Description'
and have the other field automatically update, but have been unable to do
this so far. . .



Any Help With This Would be Greatly Appreciated

Dodge
 
In each of the fields' After Update event, you must assign the lookup value
to the other field. In the ID After Update event, the code would look
something like this:
Description=DLookup("Description","Products","ProductID=" & Me.ProductID)

The code in the Description field would be looking up the ID for the
selected description.
Karen
 
Sounds Good !

I will give a whirl tomorrow, Thank you very much for pointing me in the
right direction !

Dodge
 
Back
Top