I am using 1 form for data entry and for record lookup. The source table of this form is the master table, so if a user inputs an id that exists in the master table it will fill in all fields on the form that exist in the master table. IF a user inputs an id that does not exist in the master table, then I need to use a calculation to populate the value for two fields.
For example, if id 5 does not exist in the master table then
Me!Total = SUM(price1+price2+price3+price4)
if id 5 does exist in the master table then
Me!Total = whatever the value in the table is
Second field if id 5 does not exist in the master table then
Me!Tax = Me!Total*.025
if id 5 does exist in the master table then
Me!Total = whatever the value in the table is
How can I set this up on my form fields?