G
Guest
Hi,
I have a "ProductName" table with two fields: "Product" and "ProductCode".
I have this because the product name tends to be very long and I have
thousands of products.
I have a form that populates fields in a "Customer" table listing the
product they have.
In this form I have an unbound text box named "Code". I would like to enter
the ProductCode into this text box and on exit I would like it to populate my
"Product" control in the form for that customer only. I currently do this by
running a macro that runs a query. I would rather do this through VB.
Your help is much appreciated.
I have a "ProductName" table with two fields: "Product" and "ProductCode".
I have this because the product name tends to be very long and I have
thousands of products.
I have a form that populates fields in a "Customer" table listing the
product they have.
In this form I have an unbound text box named "Code". I would like to enter
the ProductCode into this text box and on exit I would like it to populate my
"Product" control in the form for that customer only. I currently do this by
running a macro that runs a query. I would rather do this through VB.
Your help is much appreciated.