Don't want to save record??

lipin

Registered User.
Local time
Today, 05:12
Joined
May 21, 2002
Messages
149
I have a form that has a subform on it and the subform opens with the click of a button on the form. If this button is clicked inadvertantly or in error I have another button to return the focus to the main form and go on with the data entry. When I save the record it saves a blank record in the table linked to the subform. Is there a way to avoid this? I would like the button to return focus to the main form without saving the blank record of the subform. Thanks.
 
Well I had several of the fields for the subform set to required, so I couldn't close or go back to main form without getting the message "such and such is required" so I just gave them some default values of 0s.

So I see what you are saying, it is now saving all the default 0s. Should I undo defaults? How can I get it to close if some fields are required?
 

Users who are viewing this thread

Back
Top Bottom