subDatasheet setup on query behind form not being remembered

[astro]

I'm trying to get a subdataSheet embedded on a form which will be displayed
in datasheet view.

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.

Any ideas?

I using Acess 2k with sp/3...........

Thanks.

[Tim Mills-Groninger]

"astro" <as*********@mn .rr.com> wrote in message
news:B1******** *********@twist er.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