Record Set Not Updateable In A Form

[Junior]

I have created a query to update fields. This query is composed using
to other queries, each containing 3 primary fields. I have linked the
fields appropriately (or at least I think). I have absolutely no
problem updating reocrds using this query, at the query level.

I want to create a form based on this query for other users to apply
record updates. I create the form using the query, save it - and no
problems, I can update records. Seems to work great.

When I close down the form and re-open, something happens to the form
so that the record set is not updateable. What's even stranger is that
now my query (which was always working fine), is also reverted to not
updateable.

Clearly, there is something I am doing wrong when creating this form.

Any ideas/help??

GZ

 

[John Vinson]

When I close down the form and re-open, something happens to the form
so that the record set is not updateable. What's even stranger is that
now my query (which was always working fine), is also reverted to not
updateable.

Clearly, there is something I am doing wrong when creating this form.

That's very strange!

I'd suggest checking the SQL of the query before and after closing and
opening the form (copy and paste it into Notepad for example). Does
closing the form affect it? Is there any code attached to your form
that might be changing the form's Recordsource?

It's also possible that your database is corrupt. You might try
deleting the query and the form; compact and repair; recreate the
query and the form and see if that changes this odd behavior.

John W. Vinson[MVP]

 

[Junior]

That's very strange!

I'd suggest checking the SQL of the query before and after closing and
opening the form (copy and paste it into Notepad for example). Does
closing the form affect it? Is there any code attached to your form
that might be changing the form's Recordsource?

It's also possible that your database is corrupt. You might try
deleting the query and the form; compact and repair; recreate the
query and the form and see if that changes this odd behavior.

John W. Vinson[MVP]

Thanks for the suggestions. I'll give it a try.

GZ