Calculation Code of multiple forms

I

Iestyn

I am trying to work a calculation in Access 97 using three
or more variables. I then need a calculation to work out a
cost based on these variables.
Using the following code
If [Forms]![Print Summary]![Printer] = "Letter" And Me!
[Quantity] > 3000 And Me![Quantity] < 5000 Then
Me![PrintCostPM] = (Me![Quantity] / 1000) * 33
End IF
However Access is reporting that the forms Print summary
is unrecognisable.

Does anybody know why this might be happening, thanks in
advance

Iestyn
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form Not Populating Consistently! 0
Pass subform total to main form 2
Update multiple record values in form/query 0
Update multiple record values from form/query 0
Determine subform total before code runs 2
Inserting Calculation / Expression in a Form 2
Continuous forms coding suggestions needed. 2
CALCULATED VALUES IN A FORM BASED ON USER DATA INPUT 5

Top