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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need combo box to refresh when moving to new record 2017 1
adding a new record to a table from a form (works in edit mode) 3
Enable control/field if in Add New Record page/form 1
Access 2K: Refresh Combo Box after adding new data from another fo 2
Combo Box help 0
Change the DataMode of a Form (?) 3
Error in calculated fields dependent upon another field in a form 3
Can you auto write AddItem VBA code to a form to populate a Combo 5

Back
Top