saving form on close

G

Gator

I have a form with listboxes that allow me to click values that are then
added to records. Whenever I close the form, a 'do you want to save' prompt
occurs, even though I don't make any changes to the form design. What code
can I use to save the form when it is exited?
 
K

Ken Snell \(MVP\)

How are you closing the form? Using a command button? Using the Red X button
at top right?
 
G

Gina Whipp

Gator,

Happened to me once and I when I looked the RecordSource for the form had a
field that I had deleted from the table. Once I fixed the RecordSource, by
deleting that field, the error went away.
 
G

Gator

I'm not getting an error...just a save form prompt and I'm not making any
changes in the recordsource. I've noticed that it only happens when a new
record is added to the recordsource which is a query? Would the fact that it
is a query recordsource have anything to do with it?
 
G

Gina Whipp

It would not be an error, you would get a Save on Close prompt.

It shouldn't matter whether it's a query or a table, only that a field is
missing. You said previously that it happened whether you added a new
reocrd or did nothing. Are you now saying it only happens when you go to
add a new record?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Close form without saving changes 3
If I open a form, add a new record, close the form (without saving or changing records) will it stil 1
Need combo box to refresh when moving to new record 2017 1
Access Automatically Send a notification email once a record is added 0
exit form button and BeforeUpdate form event 4
Stopping automatic SAVE on close 1
vbOkCancel 4
Cancelling the close form statement. 4

Top