Buttons with conditions

  • Thread starter Thread starter Nick
  • Start date Start date
N

Nick

I want to set up a series of forms that can only be
opened once the previous form has been filled in e.g.
form number 1 has 2 fields in it, one of these fields
needs to be filled in before the user can progress to the
next form by pressing a button.

Regards

Nick
 
In the button's click eventhandler, you need to put in code
along the lines of
If Len(txtBox1) = 0 and Len(txtBox2) = 0 then
MsgBox "Please Enter Some Data"
Else
DoCmd.OpenForm "form2"
End if

You need to change txtBox1, txtBox2 and form2 to suit your app.

Hope This Helps
Gerald Stanley MCSD
 
Back
Top