Please Help? Functions in Add Mode of a Form

A

A. Smart

Good Morning,

I have a form that is opened from the seitchboard in Add Mode. In this form
I have a combo box that looks up records in the form. This combo box doesn't
work in Add Mode therefore I don't want it to be visible when the form is in
Add Mode.

Is there some code that will allow me to do this??

Thanx in advance.....
 
S

SusanV

In the forms On Load event:

If Me.DataEntry = True Then
Me.YourComboBox.Visible = False
Else Me.YourComboBox.Visible = True
End If
 
S

Sandra Daigle

In the current event of the form you can use code something like this:

me.cboMyCombo.visible=not me.newrecord

This will toggle the visibility of the control based on whether or not you
are on a new record.
 
Top