Form ControlSource Question

[RC]

I have a table named 'Inventory' that includes the
fields 'ID' and 'ProdName'. I also have a form that
includes the same two fields, 'ID' and 'ProdName'. What I
want is to type in the ID number in the 'ID' field on the
form and have it automatically return the corresponding
product name in the 'ProdName' field by referencing
the 'Inventory' table. Can anyone suggest what I need to
write in the ControlSource property to make this happen?

TIA,
RC

 

[Ken Snell]

Use a combo box to select the ID value, and then use the code at this URL to
have the ProdName appear in the textbox:

http://www.mvps.org/access/forms/frm0058.htm

 

[RC]

Thanks for the solution Ken.

RC

-----Original Message-----
Use a combo box to select the ID value, and then use the code at this URL to
have the ProdName appear in the textbox:

http://www.mvps.org/access/forms/frm0058.htm

--
Ken Snell
<MS ACCESS MVP>




.