If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#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. |
#2
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|