Lookup Field Automatically Updated from Another Lookup ? ? ?

[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

 

[TKD Karen]

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

 

[Dodge Brown]

Sounds Good !

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

Dodge