#Name?

I have a typical order entry form which has underlying tables: Order,
OrderDetail and Product. I want the form to display the default price from
the Product table but allow the user to override it and write the new price
to the OrderDetail table. I have set the Control Source for the UnitPrice
field on the form to the OrderDetail table and the default value is set to
get it's value from a query of the Product table. I can tell the query is
finding the default value from the Product table because the ExtendedPrice
field on the form has the correct value BUT the UnitPrice field on the form
displays #Name? and will not allow me to input anything into the field.

No need to reply. I've figured out my problem. I put an "After Update"
Event Procedure on the ProductID field of the form which set the default
value for the UnitPrice field on the form.

"Volta" wrote in message
...
I have a typical order entry form which has underlying tables: Order,
OrderDetail and Product. I want the form to display the default price
from
the Product table but allow the user to override it and write the new
price
to the OrderDetail table. I have set the Control Source for the UnitPrice
field on the form to the OrderDetail table and the default value is set to
get it's value from a query of the Product table. I can tell the query is
finding the default value from the Product table because the ExtendedPrice
field on the form has the correct value BUT the UnitPrice field on the
form
displays #Name? and will not allow me to input anything into the field.