Form ControlSource Question

RC · Aug 24, 2003

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 · Aug 24, 2003

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 · Aug 25, 2003

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>

.