G
Guest
I have a basic invoice program where I want to populate a form with data from
a 'Products' table. The form itself also saves user selections in a separate
'Orders' table.
When a user selects a product, I would like to set the default UnitPrice
based on the existing value in the Products table, but allow them to change
the value. In eithe case, the UnitPrice value (either default or changed)
would be saved to the Orders table.
I'm new to Access and appreciate any help in doing this.
Thanks.
-b
a 'Products' table. The form itself also saves user selections in a separate
'Orders' table.
When a user selects a product, I would like to set the default UnitPrice
based on the existing value in the Products table, but allow them to change
the value. In eithe case, the UnitPrice value (either default or changed)
would be saved to the Orders table.
I'm new to Access and appreciate any help in doing this.
Thanks.
-b