dont save changes on form

[accesshelpme]

I add record button. This brings up a form shows a blank record with only one field automatically filled out at the top based on the client on the previous form. However, the problem is, is someone exits this form it saves the record with just that one client field filled out and the rest blank. I want it so if you exit out of the form without having anything in combo1(combobox)...it wont save the new record....THANKS

 

[RuralGuy]

Use the BeforeUpdate event of the Form to issue a Me.UnDo if your criteria is not met.

 

[accesshelpme]

Well i did this in the before update and its still not working...hmmmm

If Me.Combo1.Value = "" Then
Me.Undo
End If

I also tried


If Me.Combo1.Value = null Then
Me.Undo
End If

 

[accesshelpme]

i figured it out ...thanks

 

[RuralGuy]

That's great! What did you finally end up using?