help: check box to pop up form??

  • Thread starter Thread starter reservedbcreater
  • Start date Start date
R

reservedbcreater

my Db is a house inpection survey, i want a check box to ask the user
whether or not there were renovations.....rigth when they check it i want
a a form to pop up with my renovation feilds text boxs....what is the code
to do this?
 
Somehitng like this should work...
Private Sub Check0_Click()
' you only need to open your form when they check the box, not when they
un-check it
If Me.Check0 = True Then
DoCmd.OpenForm "YourFormName"
'There are other arguments that might eb helpfull to you, look up the help
files
End If
End Sub

But you might be better off with a subform within you main form with
property Visisble =False and instead of DoCmd up there, you just have to say
me.subFrm.Visible =True

Depends what you need to do and where the data that is in your other form
will reside.
 
Back
Top