Please Help? Functions in Add Mode of a Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.....
 
In the forms On Load event:

If Me.DataEntry = True Then
Me.YourComboBox.Visible = False
Else Me.YourComboBox.Visible = True
End If
 
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.
 
Back
Top