Subforms not working

[KjWhal]

I'm not quite sure how to explain this.

The application I need to maintain has a regular form, and then a subform on it that is supposed to fill up based on a query, with each record being represented as a row and the columns have various drop down boxes or textboxes etc. Normally there will be a blank row at the very bottom for you to add another record, but its disappeared!

What is wrong and how do I fix it? I haven't tinkered with this at all so I have no idea what is wrong.

 

[RuralGuy]

I suspect either you have "Allow Additions" set to *No* or your SubForm has a NonUpdateable query as a RecordSource.

 

[KjWhal]

I suspect either you have "Allow Additions" set to *No* or your SubForm has a NonUpdateable query as a RecordSource.

Allow additions is set to yes. The query has never changed since I started working here. And this problem affects every subform in the application, which has several different ones.

Edit: I can't make any changes to the controls that do populate either.

 

[RuralGuy]

Is your application Read Only for some reason?

 

[KjWhal]

Is your application Read Only for some reason?

No. Neither is the database. I can make changes in controls on regular forms, this only seems to affect subforms.

 

[RuralGuy]

Only SubForms on this Form or all of the SubForms on *all* of your forms?

 

[RuralGuy]

Any chance you can post a sample of the db with any sensitive data removed but with enough sample data to demonstrate the problem?

 

[KjWhal]

Only SubForms on this Form or all of the SubForms on *all* of your forms?

All of the subforms on all of my forms.

Can't post a db any time soon unfortunately.

 

[RuralGuy]

Be sure and Compact and Repair and try it before zipping up the db to post.