Afterupdate Code Question

  • Thread starter Thread starter scott04
  • Start date Start date
S

scott04

I am using the following code to disable the date field if the yes/no box is
null or false:
Private Sub Combo33_AfterUpdate()
Me.Ctl1st_Date.Enabled = Nz(Me.Combo33, False)
Me.Most_Recent_Date.Enabled = Nz(Me.Combo33, False)
End Sub

What can i place in this code so that it also deletes whatever date was in
this field if it is selected as N or False? Any help is appreciated. Do I
also need to place this in the beforeupdate of the form?
 
Nevermind I just added:
If Me.Combo33 = False Then
Me.Ctl1st_Date = Null
Me.Most_Recent_Date = Null
And it works fine
?
 
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

Run Time Error 3075 2
Synchronizing Form and ComboBox 1
Excel Code to run ActiveWindow.View in normal view, only runs manually. 21
Can't get debug to break 1
Unbound combobox AfterUpdate 5
Vb code working one time 1
before update 5
MS Access setting outlook reminders from a DAO recordset 0

Back
Top