Making a box both modifiable or an autolookup

[SDDIamonds]

Can anyone help me? I need to have the unit Price field
on my form - look up a price from my products tbl and be
able to make a new price for it in the form if I need
to. . . Please Help!

 

[Allen Browne]

Use the AfterUpdate event procedure of your ProductID combo to lookup the
price, and assign it to the UnitPrice field.

There is an example of that in the Northwind sample database, Order Details
form, ProductID_AfterUpdate.

If you are unsure how DLookup() works, see:
http://members.iinet.net.au/~allenbrowne/casu-07.html