Showing Lookup Results 1

[Guest_imported]

Hello,

I am trying to create a form that will allow
the user to choose a record from a table (using
a lookup), but once that record is chosen I would
like to display fields associated with that record
in text boxes on the form (eg. the user chooses a [PO_NO]
from a list of [PO_NO] & [DESCRIPTION]'s looked up
into a combo box, now i want to show the associated
[DESCRIPTION] in an uneditable text box next to it.

How do i go about doing this?

Thanks.

 

[JerryDennison]

Add the PO table to the recordset's underlying query linked to the current table via the PO number. You may need to set the link to include all records for the main table and only those matching from the PO table. Add the description field to the QBE grid. It will now be in your field list. Place the descriptor field on your form then set it's enabled property to no and it's locked property to yes. Now anytime a user selects a PO the description will appear.

 

[Guest_imported]

Thank you so much.
An obvious solution, but I had no idea.
Thanks again.