"astro" <as*********@mn.rr.com> wrote in message
news:B1*****************@twister.rdc-kc.rr.com...
.... I setup the 'record source' for the form to a query on a table. I go into
the query properties and setup a subdatasheet. I test this and it works.
I
close the query builder - get prompted to save - reply yes. I reopen the
'record source' and the subdatasheet setting are gone.
I've found this happens occassionaly. Sometimes Access just gets grumpy and
stops saving changes. Sometimes closing all objects except the one you're
working on, expliciting saving, then exiting Access are restarting the
application is the only thing that works.
I've also found trouble saving with spotty network connections - not bad
enough to drop the connection or corrupt the database. Making the fixes
locally, then copying back to the network share is the only solution I've
found for that.
hth
Tim Mills-Groninger