Enable/Disable Control on Form Open

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

Guest

I have a form called frmGroups. When I open this form in "add" mode, I would
like to disable the cboFindGrp control. When I open this form in "edit"
mode, I would like this control to be enabled.

How do I do this?
 
When you OpenForm add mode, its DataEntry property is True.

Private Sub Form_Open(Cancel As Integer)
Me.frmGroups.Enabled = Not Me.DataEntry
End Sub
 
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

Syntax Error (Missing Operator) 3
Enable control/field if in Add New Record page/form 1
Use of RecordSet 4
Syntax for enabling and disabling controls 3
How to Correctly Enable/Disable controls with Form_Current 1
Form not opening to new record 5
Change the DataMode of a Form (?) 3
toggle button nightmare 3

Back
Top