Auto populate fields from another table

[JoeAccessHelp]

Hi all

Is it possible to auto populate a field depending what is put in another field. E.g. I have 'product code' and 'Product name'. When raising the Invoice I would like to be able to enter the code or the name and the other one populate automatically.

Thanks
Joe

 

[Ranman256]

Yes, create an update query,
join the entry table to the lookup Table on the common field, CODE.
Update the entry table fields with all fields needed from the lookup product table.

To update :
Docmd.openquery "quUpdProdFldsQry"

 

[pbaldy]

Or:

http://www.baldyweb.com/Autofill.htm