Continuous Forms and making a field invisible depending on another field

[rcwoodard]

Hello all.

I have a continuous form that I need to make a field invisible or visible depending on the selection in another field. I have tried using Form_Current() and the following code:

Private Sub Form_Current()
     If VisitType = 3 Then
          Me.cboMonitor.Visible = True
     Else
          Me.cboMonitor.Visible = False
     End If
End Sub

Of course this does not work. It changes all of the records based on the selected or active record. I am using Access 2003 on Windows XP Pro.

Am I just being silly and overlooking something or does someone have a wise and masterful solution.

Thanks

[MMcCarthy]

In form design view go to the Format - Conditional Formatting. It won't allow you to toggle visible and invisible but it will allow you to disable the combobox.

[rcwoodard]

In form design view go to the Format - Conditional Formatting. It won't allow you to toggle visible and invisible but it will allow you to disable the combobox.

How would I go about doing this?

Thanks

[missinglinq]

Click on the combobox to select it
Goto Format > Conditional Format
In Condition select Expression Is
In the box to the right type VisitType <> 3
You'll see B(old) I(talics) U(nderline) ForeColor BackColor Enabled
Click on Enabled (which looks like a rectangle with squiggles inside it)
This actually sets Enabled to False

Good Luck!

[NeoPa]

How would I go about doing this?

Thanks

The instructions are in Mary's post (#2).
What precisely, are you having trouble with?

*edit*
Didn't catch Linq's post. No need to respond to this directly if that post (#4) gives you what you need.