Hello,

I have some fields which become visible after I've checked a box:

Private Sub Trigger()
If (Me.Trigger = True Or Me.Trigger = Not Null) Then
Me.Problem.Visible = True
Else
Me.Problem.Visible = False
End If
End Sub

The trigger-checkbox has "Default Value = False"
The Problem-field has property "Visible = NO"

I create a new record.
The problem field is not visible. OK.
I check the Trigger and the problem field becomes visible. OK.
I click on >* (the new-record button) and the problem field is still
visible?!?

What can I do to make sure that the invisible fields are ALWAYS
invisible in a new record?

Thanx!

The test:
Me.Triger = Not Null
will never be true. Try:
Not IsNull(Me.Trigger)

For an explanation see:
Common errors with Null
at:
http://allenbrowne.com/casu-12.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to the newsgroup. (Email address has spurious "_SpamTrap")

"rweijers" <rob_weijers (AT) hotmail (DOT) com> wrote

rob_weijers (AT) hotmail (DOT) com (rweijers) wrote in
news:7a30f274.0307290718.17f2b5fa (AT) posting (DOT) google.com:

I assume trigger is unbound to any field in the form.
First analyse your condition.
If not isnull(me.trigger) then
I doubt that this is really what you want to test. Since it is unbound,
trigger will stay not null until the form is closed.

Change the test to If me.trigger = true
In the OnCurrent event, set problem.visible = no
This will solve your problem.

Bob