Form doesn't allow data entry

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that decided to no longer accept data entry and I cannot figure
out why. It's based on a query and if I copy that query (SQL text) to a new
form, it doesn't allow data entry either. I've looked all over for a setting
to change, but I'm befuddled.

I'll probably have to answer some specific questions before I get this
figured out, so please ask and I'll watch here.

Thanks in advance.

Jerry
 
Try opening the query directly. Can you enter data there?
If the query is read-only, the form based on the query will be read-only
also.

If the query works fine, check the AllowEdits property of the form.
 
I cannot enter directly into the query either. AllowEdits is set to Yes on
the form. How/where do I see if it's read-only?
 
Okay, you have established that the query is the problem.

Remove some of the tables from they query, until you can update it.
 
While waiting for your answer, Allen, I played with the query and determined
that one of the tables is the culprit, but I still don't know how to fix it.
The query uses 3 tables and when I use one of them, I cannot update the query.

Now what?

Jerry
 
You need to redesign your interface (or possibly your data structure).

For example, you might remove one of the related tables, and use a subform
to enter that info, or remove one of the lookup tables, and use a combo box
on the form to display the lookup value.
 
Thanks for your persistenct patience with me last night, Allen. I got it
fixed before going to bed. I was only drawing one field from the "culprit"
table, so I used a DLookUp field and it's working fine. Again, Thanks, and
have a great Thanksgiving.

Jerry
 
Back
Top