saving form on close

[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?

 

[Ken Snell \(MVP\)]

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

 

[Gator]

both

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

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/

 

[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.

 

[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?

 

[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?

 

[Ken Snell \(MVP\)]

What is the RecordSource for the form? What do you do on the form?

 

[Linq Adams via AccessMonster.com]

"I have a form with listboxes that allow me to click values that are then
added to records."

"I'm not making any changes in the recordsource."

These two statements are mutually exclusive. If you've "added values to
records" you have made changes to your recordsource.

Is this warning referring to the form itself or to the data in the current
record? It sounds like the latter.