saving form on close

  • Thread starter Thread starter Gator
  • Start date Start date
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?
 
How are you closing the form? Using a command button? Using the Red X button
at top right?
 
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.
 
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?
 
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?
 
Back
Top