setting default values based on another control value

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Have you looked at the Northwind database that ships with Access? It has
all this stuff covered. Maybe you can copy their functionality.
 
Back
Top