Hiding a form

[jman]

I'm an intern and have been basically thrown into the world of Access so I am
basically teaching myself.

I have a form with a yes/no box. If the answer is yes, I would like to ask
for additional information which I then plan to use in combination with other
form information to create a unique report. I do not want this information
always visible though. Is there a way (possibly using subform?) to hide the
form until the yes/no box is clicked as yes?

Also, is there a way to make that clicked yes/no box translate into a word
yes/no in a report?

 

[Lynn Trapp]

You obviously don't want to hide the form until the 'yes' answer is given,
because then you couldn't see the checkbox in order to click it. Instead,
you need to hide all the other fields until it is clicked. In the Click
event of your yes/no control, put the following code.

Me.SomeField.Visible = Me.YourCheckBox

You will also want to put it in the Current event of the form. Put that code
in both events for each field on the form.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[jman]

I think I was unclear when I asked my original question. I was asking to hide
the fields in the form related to whether the answer of the checkbox was yes
or no. That's why I asked about maybe using a subform.

Also, when I put the code in where you instructed me to it said Me is not a
valid macro.

I have Access XP (which translates to Access 2002) if that makes a difference.

 

[Lynn Trapp]

Ok, that's what I thought you might be thinking but wanted to make sure. The
subform is unnecessary to do what I suggested.

Where did you put the Code? Did you just enter it in the Properties window,
or in the module for the event?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[jman]

I entered it into the properties window.

 

[Lynn Trapp]

Open the Property window. Click in the event you need. Click the button to
the right end of the field (it has 3 dots at the bottom). It will ask if you
what you want to open. Select Code window and put your code in the module
that opens.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[jman]

When I put the "Me.SomeField.Visible = Me.YourCheckBox" code in for the
current it told me "Compile error: Method or data member not found."

This was the code as I entered it:

Option Compare Database

Private Sub Form_Current()
Me.SomeField.Visible = Me.YourCheckBox
End Sub

Private Sub Inspection_required_Click()
Me.SomeField.Visible = Me.YourCheckBox
End Sub

Private Sub Revision_Level_Click()
Me.SomeField.Visible = Me.YourCheckBox
End Sub

Revision level was the thing I was trying to hide. Inspection required was
the yes/no.

 

[Lynn Trapp]

I'm sorry but I was being 'cryptic' since I don't know the actual names of
your controls. You need to replace 'SomeField' with the actual name of your
textbox and 'YourCheckBox' with the actual name of your check box.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html