Question about forms...

[Kevo]

Yet another question. Sorry!

Ok, here is what I would like to do. Please let me know if there is an easier way or what I should research/learn.

Can you create a form that asks for certain info....but if, let's say, a toggle switch is selected, then the form would ask for additional info?


In other words, can you have fields in your table that only are visible on your form if a selection is made?

Thank You,
Kevin

[pbaldy]

Wouldn't be much of a forum if nobody was asking questions!

Is this what you're looking for?

http://www.baldyweb.com/ConditionalVisibility.htm

[Kevo]

Thanks a bunch Paul!

I am so glad that access is finally starting to make a little sense.
I know just enough to be dangerous!

So, I followed your suggestion and put this

Private Sub Check40_AfterUpdate()
If Me.Check40 = True Then
Me.Combo25.Visible = True
Else
Me.Combo25.Visible = False
End If
End Sub

in the After Update of a toggle control. It works great.

Now if I may ask you for a little more.... I am just beginning to learn VBA so I am sure this is an easy answer, but I would like to make 3 controls visible or not depending on the toggle.

What is the proper language for combining more than one?

Is it:

Private Sub Check1_AfterUpdate()
If Me.Check1 = True Then
Me.Combo1.Visible = True & Me.Combo2.Visible = True & Me.Combo3.Visible = True
Else
Me.Combo1.Visible = False & Me.Combo2.Visible = False & Me.Combo3.Visible = False

End If
End Sub

Thanks again for the help....You folks in this forum are making me look really smart at work.

[Kevo]

Never mind Paul..... Duh, I figured it out.

But someone can still let me know if this is proper code.

Private Sub Check1_AfterUpdate()
If Me.Check1 = True Then
Me.Combo2.Visible = True
Me.Combo3.Visible = True

Else
Me.Combo2.Visible = False
Me.Combo3.Visible = False
End If

Thanks

[Kevo]

Ok, spoke too soon.

This works great except when I go to my next record it remembers the toggle from the last record and does not "record" the first?

Hope that makes sense.....

I want the toggle to record a "yes" in the corresponding field in the record as well as showing or not showing the other 3 fields.


In other words,


Is this an "Immediate Utilization Sterilization Load"? (if yes then)


the following 3 fields are visible


Cycle Temp:

Cycle Time:

Reason For IUS Load:


And I will end up with the 4 fields (IUSLoad, CycleTemp,CycleTime,IUSReason) recorded in my table along with the other fields that come before this on the form.

[pbaldy]

From the link: "You might also want the code in the Current event, which would fire when you change records".