Look into the on_current property, and the visible property.
Psuedo code to foolow:
Control_1 on_current
If me.value = 10 then
control_2.visible = true
End If
End sub
In the on open event of the form, set control_2s visible property to false,
also.
In the on click event of the add new record button, set control_2s visible
property to false, also.
HTH
--- On Tue, 11/10/09, rkulez <rku...@yahoo.com> wrote:
From: rkulez <rku...@yahoo.com>
Subject: [ms_access] invisible control
To: ms_access@yahoogroups.com
Date: Tuesday, November 10, 2009, 6:23 AM
Dear group members,
I have a form with two controls named ctrl_1 and ctrl_2.
1) I wish ctrl_2 will be invisible when the form is loaded(opened? )
2) I wish when ctrl_1 takes the value "10" ctrl_2 become visible.
3) I wish when I want to make a new record (when I click new record button) and
see the form again ctrl_2 become invisible.
I have accomplished the first and second tasks but couldn't the third one.
Can you please give an advice?
Best wishes to all..
Ruhi
[Non-text portions of this message have been removed]
