NeoPa, the error is triggered on line 4, If Me.TriagNum.Val ue = True Then .
If I comment out that line, the error still occurs, but on line 7, If Me.PulmStatus.V alue = True Then . This is a report, TriagePercent is a text box. The report is not called TriagePercent, so no confusion there. As far as I know, there is a Before Update event since it appears in my program as a possible selection choice... ?
ChipR, I tried your suggestion...
User Profile
Collapse
-
Access VBA cannot find "variable"
Hello,
I am having trouble with my database in Access. The problem lies in my report. I have created a report based off a query. The query contains all values that I'll need for my report- some will be directly on the report in text boxes, etc and others will be needed for calculations only and so are not directly on the report. My problem is when I'm writing the code for my text box "TriagePerc ent" which should, based on the AuditNum...
No activity results to display
Show More
Leave a comment: