I am trying to validate data that when the user goes to the form and goes from report #1 to report #2 is there are any nulls from report #1 it will not let them move on. Before and After Update requires that data has to be chnaged, right? What can I do to force validation if no data was entered and the report was skipped completely?
Validation Question
- Thread starter ksmithson
- Start date
ghudson
Registered User.
- Local time
- Today, 17:38
- Joined
- Jun 8, 2002
- Messages
- 6,187
Are you calling your text box's "report #1 & #2"?
You can set validation up so that a user cannot move to another record or field [text box] or open a report, etc. if a field is null. Use the forms Before_Update event to trap it. Search the forum for there are plenty of example coding and suggestions with more specifics. The Before_Update events will only fire if the current record has just been modified or is a new record.
You can set validation up so that a user cannot move to another record or field [text box] or open a report, etc. if a field is null. Use the forms Before_Update event to trap it. Search the forum for there are plenty of example coding and suggestions with more specifics. The Before_Update events will only fire if the current record has just been modified or is a new record.
And I thought this was being answered here?
http://www.access-programmers.co.uk/forums/showthread.php?t=195967
http://www.access-programmers.co.uk/forums/showthread.php?t=195967
Not when you exit the form but when you go to the next record in the form.
boblarson
Smeghead
- Local time
- Today, 14:38
- Joined
- Jan 12, 2001
- Messages
- 32,025
Okay, I can see where there might be a difference in what is trying to be accomplished but I think we need more information again. What do you mean Report #1 and Report #2 (when moving from record to record)? I think a screenshot or two might help us understand your use of the form.
Similar threads
