J
JR Brown
I have a form "Info" which has a default field filled in "=date()" when I
click the exit button it adds another record but everything is blank except
the autonumber and the date field. this also happens when I hit the clear
fields button.
Here is the code for the exit button...
DoCmd.Close acForm, "Info"
and for the clear fields button...
cboDate = Date
txtName = Null
txtZipCode = Null
cboBranch = Null
txtPhone = Null
txtEmail = Null
cboContactMethod = Null
cboBest = Null
I am trying to make it so it does not add a new record when these buttons
are hit. Thanks for your suggestions in advance!
click the exit button it adds another record but everything is blank except
the autonumber and the date field. this also happens when I hit the clear
fields button.
Here is the code for the exit button...
DoCmd.Close acForm, "Info"
and for the clear fields button...
cboDate = Date
txtName = Null
txtZipCode = Null
cboBranch = Null
txtPhone = Null
txtEmail = Null
cboContactMethod = Null
cboBest = Null
I am trying to make it so it does not add a new record when these buttons
are hit. Thanks for your suggestions in advance!