Software

Ask something
Question Locked

How do I require data entry in a field?

0 helpful
2 replies

by jgitter

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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?

2 replies

by slayer_

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 :)

This discussion is closed to new replies.