Record Set Not Updateable In A Form

  • Thread starter Thread starter Junior
  • Start date Start date
J

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
 
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.
Click to expand...

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]
 
John said:
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]
Click to expand...

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

GZ
 
Back
Top