Frustrating data entry problem

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

I have a very frustrating problem. I had a perfectly working app with a sub
form on a main form. I added a few fields in tables here and there and now I
can not enter data on in the sub form for some of the main form records. The
sub form simply does not accept any keys. Also the drop downs drop but when
I click to select nothing happens and drop down list just remains dropped.

What could be the reason for this? Driving me crazy.

Thanks

Regards
 
Your subform is tied to your main form by some sort of table relationship,
correct? I suspect that you do not have a current record in the subform and
there is nothing to enter data into. You might want to examine the child and
parent fields that tie the forms together and see how they are affected by
the nw fields that you added.


Bill Nicholson
Cincinnati, OH USA
 
1. Is the subform based on a query? If so, open the query directly, and see
if you can change the data there. If the query is read-only, you will not be
able to change the data in the form.

2. In the Database window, open the subform directly, in design view. Check
these properties for the form:
- AllowEdits
- AllowAdditions

3. Still in design view, check these properties for some of the controls:
- Locked (should be no)
- Enabled (should be yes)

4. Close the subform, and open the main form in design view. Click the edge
of the subform, and check that the title of the Properties box says
"Subform/subreport". Check the Locked and Enabled properties of the subform
control.

5. If you are still stuck, there may be a partial corruption. Turn off the
Name AutoCorrect boxes under Tools | Options | General, and then compact the
database: Tools | Database Utilities | Compact.

Other possiblilities include permissions (Access security or network), or
read-only media.
 
Back
Top