Question

Locked

How do I require data entry in a field?

By jgitter ·
I have an Access 2007 multi-tab data entry form. The first tab contains fields to gather basic information about a claim, including claim and account number. The claim and account numbers are used as indexes to link sub-forms located on other form tabs. When entering a new record I want to require that the claim and account numbers are entered before the user can open another tab or move to another field anywhere on the form. How can I do that?

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Easy

by Slayer_ In reply to How do I require data ent ...

On Query_close event of form
If trim$(texxt1.text) = "" then
cancel=true
call msgbox("You must enter data to continue")
end if


You might want to look up some Access VBA tutorials :)

Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums