Form that won't allow entering of text into any fields

[MorningStarFan]

Hi,
Our management form would not allow any text to be edited for any field on
the form regardless of whether the field was locked or not. I had found a
way to bypass this by moving the fields to another form and selecting from a
renamed table and renamed query with rebound fields. At first it worked but I
discovered that the table relationships weren't correct. I then relinked all
the tables to re-establish the correct relationships and voila the form does
not allow data-entry for any field again regardless of whether the field is
locked or not. I don't find any code in the form module that would be doing
anything behind the scenes like this. Does anyone know where I else I could
look? Any suggestions besides completely rebuilding the form?

Thanks!

 

[ruralguy via AccessMonster.com]

It sounds to me like your form is bound to a non-updateable query. Search
for "Troubleshoot Queries" in Access help for some suggestions.

 

[MorningStarFan]

Thanks ruralguy! You were right. I've built another query and the form works
fine. Now how do I get to that property (update or non-update) for a query?
Or will I always have to rebuild if this happens again?

 

[ruralguy via AccessMonster.com]

I'm not sure what your question is. A query does not just turn NonUpdateable.
It is either updateable or NonUpdateable. If you create an Updateable query,
unless you change somethig in the structure of the query it will remain
updateable forever. I'm not sure I answered your question.

Thanks ruralguy! You were right. I've built another query and the form works
fine. Now how do I get to that property (update or non-update) for a query?
Or will I always have to rebuild if this happens again?

It sounds to me like your form is bound to a non-updateable query. Search
for "Troubleshoot Queries" in Access help for some suggestions.

[quoted text clipped - 12 lines]

 

[MorningStarFan]

Sorry to be so unclear. My question should have been worded as below...

How do I create a non-updatable query?

--
MorningStarFan

I'm not sure what your question is. A query does not just turn NonUpdateable.
It is either updateable or NonUpdateable. If you create an Updateable query,
unless you change somethig in the structure of the query it will remain
updateable forever. I'm not sure I answered your question.

Thanks ruralguy! You were right. I've built another query and the form works
fine. Now how do I get to that property (update or non-update) for a query?
Or will I always have to rebuild if this happens again?

It sounds to me like your form is bound to a non-updateable query. Search
for "Troubleshoot Queries" in Access help for some suggestions.

[quoted text clipped - 12 lines]

Thanks!

 

[MorningStarFan]

Essentially my problem is solved so this is only for future reference or
general knowledge but you said "unless you change something in the structure
of the query" the query will remain updatable. I'm looking for what can be
changed to make a query non-updatable. I imagine it's a number of things...
I've looked in "Troubleshooting queries" and that wasn't real helpful on this
question.
--
MorningStarFan

Sorry to be so unclear. My question should have been worded as below...

How do I create a non-updatable query?

--
MorningStarFan

I'm not sure what your question is. A query does not just turn NonUpdateable.
It is either updateable or NonUpdateable. If you create an Updateable query,
unless you change somethig in the structure of the query it will remain
updateable forever. I'm not sure I answered your question.

Thanks ruralguy! You were right. I've built another query and the form works
fine. Now how do I get to that property (update or non-update) for a query?
Or will I always have to rebuild if this happens again?
It sounds to me like your form is bound to a non-updateable query. Search
for "Troubleshoot Queries" in Access help for some suggestions.
[quoted text clipped - 12 lines]

Thanks!

 

[ruralguy via AccessMonster.com]

That actually has a complicated answer. Did you look in Access Help (not VBA
Help) under "Troubleshoot queries"? Look in the Select queries in the lower
"Specific types of queries" section. There are several descriptions under "I
can't update data from a query". Good luck.

Sorry to be so unclear. My question should have been worded as below...

How do I create a non-updatable query?

I'm not sure what your question is. A query does not just turn NonUpdateable.
It is either updateable or NonUpdateable. If you create an Updateable query,

[quoted text clipped - 9 lines]

 

[ruralguy via AccessMonster.com]

I would like to have been more helpful on this point but as I said the answer
is complicated. Generally it becomes NonUpdateable when Access can not
determine which record to update. Not much help I know but you will really
have to tackle each issue separately. Just recognize when that is the issue
that is causing the problem. If you have a static query that can be viewed
in the query builder then viewing it in DataSheet mode and trying to change
something will tell you whether or not it is updateable. It beeps at you if
it is *not* updateable when you try and change something.

Essentially my problem is solved so this is only for future reference or
general knowledge but you said "unless you change something in the structure
of the query" the query will remain updatable. I'm looking for what can be
changed to make a query non-updatable. I imagine it's a number of things...
I've looked in "Troubleshooting queries" and that wasn't real helpful on this
question.

Sorry to be so unclear. My question should have been worded as below...

[quoted text clipped - 13 lines]