Stop form from saving Rec or Undoing

[dead7]

I have a form that when you open it it saves the record, How can I stop it from doing that if I dont want the record saved I tried
If IsNull([BENE_NAME]) Then
Me.Undo
End If
Is there a save record false or maybe onclose event to say dont save the current record unless a field is filled in

 

[snyperx3]

You can set that in your table definition.
On that certain field set the Required property to YES.


-Pete

 

[PHV]

Have a look at the BeforeUpdate event of the Form object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[TheAceMan1]

How are ya dead7 . . .

[blue]There's no way you can open a form and have it save a record, unless you have intervening code! . . .[/blue]

Check the code module of the form and post back where this condition exist! . . .

See Ya! . . . . . .