lookup tables

[nkuebelbeck]

I am trying to create a form where the user looksup up a product(combo box) and when the product is selected it fills in another field to the right automatically. Both product description and price are in a lookup table.



Is this possible? Never done this before.

building this in access 97 for legacy purposes.

I've attached a photo of what i am trying to do.
Thanks

[pbaldy]

Fairly easy. For display, this as the control source of the textbox:

=ComboName.Column(1)

If the value needs to be saved (thus the textbox needing to be bound to the table), this in the after update event of the combo:

Me.TextboxName = Me.ComboName.Column(1)

[nkuebelbeck]

Once again, thanks!

Kudos!

[pbaldy]

No problemo!