M
Maurita
Hi, hope someone can help me with a problem I can't seem to solve. I
have a form with a command button which adds a new record on a form.
On the form, I also have two unbound text boxes that I need to clear
when I click on the command button to add a new record. When I click
on the command button, the fields clear, but I get an error that
states that access can't find the macro; but I've not created any
macros. Along with the code that Access put in for the add new record
button, I also used the following code:
Dim ctl As Control
On Error Resume Next
For Each ctl In Me.Controls
With ctl
.Value = Null
End With
Next
I appreciate any help in this matter. I am at a loss as to what I'm
doing wrong.
Thank you.
Maurita Searcy
have a form with a command button which adds a new record on a form.
On the form, I also have two unbound text boxes that I need to clear
when I click on the command button to add a new record. When I click
on the command button, the fields clear, but I get an error that
states that access can't find the macro; but I've not created any
macros. Along with the code that Access put in for the add new record
button, I also used the following code:
Dim ctl As Control
On Error Resume Next
For Each ctl In Me.Controls
With ctl
.Value = Null
End With
Next
I appreciate any help in this matter. I am at a loss as to what I'm
doing wrong.
Thank you.
Maurita Searcy