Made a Mistake, Please Help!!!

[CEVisker]

I believe that I was in the Form Properties when this happened. When
viewing my forms, I can no longer see the data entry fields in the
subform, but I can see them while in design view. I have been trying to
figure this out for an hour now, and I cannot find it!!

Thanks,

Chad

 

[Dirk Goldgar]

I believe that I was in the Form Properties when this happened. When
viewing my forms, I can no longer see the data entry fields in the
subform, but I can see them while in design view. I have been trying
to figure this out for an hour now, and I cannot find it!!

Thanks,

Chad

That usually happens when a form (or subform in this case) has no
records to display and no records can be added. Do you expect there to
be records displayed in the subform, or were you expecting a blank
record for adding data? Did you set the AllowAdditions property on the
subform to No? Or did you maybe change the recordsource query of the
subform such that it is no longer updatable?

 

[CEVisker]

Allow additions is set to yes on the subform. The record source is the
appropriate table and has not changed. I still am not able to figure
this one out.

Thanks,

Chad

 

[Dirk Goldgar]

Allow additions is set to yes on the subform. The record source is the
appropriate table and has not changed. I still am not able to figure
this one out.

Hmm. Has the database somehow been opened read-only? Check the
attributes on the .mdb file itself. The subform's recordsource is the
table itself, and not a query? If you open the recordsource directly --
whether a query or a table -- can you edit and add records? Is the
subform control (on the main form) enabled? You didn't answer my
question about whether existing subform records are properly displayed.
Are they?

Just as a shot in the dark, check the Name Autocorrect option in your
Tools -> Options -> General dialog. If it's currently enabled, turn it
off.