Using Checkbox to clear field

[rob0829]

I've done some googling and I can't seem to find a way to get this to work:

I have forms setup with checkboxes for different levels of Approval. When an approve checkbox is ticked it automatically populates the current date. I want to add a "Rework" checkbox where for example if Approver 1 approves and it records that date, then Approver 2 wants some rework to be done they can check the "Rework" box and it will clear the date recorded for Approver 1 to make the item appear back in their list. I can't seem to get the date to clear with the checkbox. This is what I have so far.

*This part works* - Records date if Approver 2 approves
Private Sub Approval2_AfterUpdate()
If Me.Approval2 = True Then
Me.Second_Approval = Date
End If
End Sub

*DOES NOT WORK* - Doesn't clear the date that was recorded for Approver 1
Private Sub Rework_AfterUpdate()
If Me.Approval2 = True Then
Me.First_Approval = Null
End If
End Sub

[ranman256]

That is correct IF the TEXTBOX for the date field is called 'First_Approval'
sometimes they have the same name as the field but not always.

sometimes if you use field names with spaces you must use me.[First Approval] in brackets, but usu the underscore works too.

note: DONT put spaces in your fieldnames.

[rob0829]

I've gone back and removed all the spaces in "First Approval" to make it "FirstApproval" however when I'm typing its still prompting me for "First_Approval" as seen in the screen. I've I remove the underscore I get an error, if I leave it it doesn't work.

I should mention that this form is linked to a Query and then back to a table. I'd like to delete the date from the underlying table.

[June7]

Shouldn't that be:

If Me.Rework = True Then


You changed field names in table? Did you also change the textbox names to reflect the same? I always give bound controls a name different from the field, such as tbxSecApp

[Micron]

I've gone back and removed all the spaces in "First Approval" to make it "FirstApproval"

Where? It looks like you didn't change it on the form itself as you seem to have a control with the old name. Me refers to the form. Me.Something, the Something refers to an object on the form. It isn't a reference to any underlying table or query field name. Using a form wizard will create controls with the same names as fields, which IMHO is not a good thing. If I use a wizard, I immediately rename the controls as per conventional wisdom, which may differ slightly from other people's habit. FirstApproval might become txtFirstApproval or cmbFirstApproval, depending on what type the control is. Others like cbo for combo.

[rob0829]

Shouldn't that be:

If Me.Rework = True Then


You changed field names in table? Did you also change the textbox names to reflect the same? I always give bound controls a name different from the field, such as tbxSecApp

Good eye! This was exactly my problem. I mistakenly wasn't pointing to the "Rework" checkbox.

Thanks everyone!!