Filter by Form requires form save on close

  • Thread starter Thread starter JP
  • Start date Start date
J

JP

I have a command button that opens the Filter by Form
screen for "Advanced" searches of my database. When the
records are filtered and two users are using the DB, a
window opens requiring the user to Save the change. Most
of the users are inexperienced with Access and will not
want to save, but it is required to exit.

Any ideas on how I can either not allow saves and remove
the popup box while not changing the functionality of the
form, or how I can automatically save the change without
user input? The Filter property changes, but this doesn't
effect the DB in any way.

Thanks.
 
Thanks, worked well.
-----Original Message-----
Hi JP,

If you don't already have a "Close" command button on the form, add one and
put this code in the Click event:

DoCmd.Close acForm, Me.Name, acSaveNo

Set the following options on the form:

Border Style: Dialog
Control Box: No
Min Max Buttons: None
Close Button: None

This will force the user to use the command button to close the form which
will run the DoCmd to close without save.

Hope this helps,
- Glen




.
Click to expand...
 
Back
Top