Difficulty with expression

G

gethrog

I have been working on this assignment for a week. I am almost there but have
struck a bug. Even my teacher says it should work, but it doesn't.
The assignment is to create a database for a wedding photographer. The
photographer offers 3 photo deals, "basic" $400, "special day" $500 and
"traditional" $700. A customer chooses a deal from a table then makes a
series of payments against the price. The database ads the payments and
subtracts them from the price of the deal selected and then displays the
balance owing.

The expression was written to subtract the total of the amounts paid from
the deal price. What happens is that when a payment is made, Acces asks for
the deal to entered manually rather than taking the selected deal from the
table. Once the deal is entered manually the calculation works. Why won't
the expression take the selected deal from the table?

EXPRESSION

OpenForm : [wedding]![Deal]=[Forms]![Deal]![Deal]
SetValue : Item : [Forms]![Wedding details]![Paid]
Expression: [Forms]![Reciept]![Paid]+[Forms]![Wedding details]![Paid]
SetValue : Item : [Forms]![Wedding details]![Balance]
Expression: [Forms]![Deal]![Cost]-[Forms]![Wedding details]![Paid]
Close: form, deal
Close

DATA IN DEAL TABLE (holds deal type and cost)

Deal Cost
Basic $400.00
Special Day Deal $500.00
Traditional Deal $700.00

DATA in WEDDING TABLE (This holds payments and original cost of deal)

Wedding number Location Date Balance Paid Deal
Time

Thanks in advance.
Gethrog

Always grateful for help given "freely"
 
K

Ken Snell [MVP]

Your syntax for the OpenForm argument makes no sense. What are you trying to
do in that macro step?
 
Top