Simple search

[jsaaved2]

Hi! I have a very simple databas with some product codes and a location related to each one. I am trying to set up a form to add the product code and that automatically (or clicking a botton) it will show the location. I do not want the search to go back to the data table and show me the prodcut code and location in the table; I want it to be shown in the same form. What is the easiest way to do this?


Thanks!!!!!

[NTC]

I trust that the form is bound to a table. In this table - the field that will hold the product info should set up as a Lookup field type that links over to your Product Table.

When you set it up be sure to include the Location field to display also in the look up query.

Then in the form you put a little vb code in the AfterUpdate event of the product field that "pushes" the location info over into the location field:
me.locationfieldname = me.productname.column(3)

something along these lines.....

[jsaaved2]

Thank you taht did help