Enable/disable subdatasheet control

  • Thread starter Thread starter Mary
  • Start date Start date
M

Mary

On which event do I place the code to enable/disable a
subdatasheet control depending on the value of a field in
the main form? When I place it in the subds.enter event
it works the first time but subsequently gives a "You
can't disable a contol that has the focus" even when the
focus has been returned to the main form. Thanks for
your help,
Mary
 
In the On Open Event in the main form have an if then else
check the value of the field you want to use to
enable/disable the sub form.

Private Sub Form_Open(Cancel As Integer)
If Me.Date = Date Then
Me.btnAppendOrders.Enabled = False
Else
Me.btnAppendOrders.Enabled = True
End If
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

Expanding a multi-level subdatasheet form using VBA 0
How to Correctly Enable/Disable controls with Form_Current 1
ApplyType is always 1 for Toggle Filter 0
SetValue from Form utilizing Subdatasheet Form 1
read focus of controls 1
Subform reference problem 2
Disable a checkbox 2
Disable buttons while "calculating..." 4

Back
Top