My Application has suddenly started playing up

[Stapes]

Hi

I have been working on a project for 6 weeks now. Suddenly, a form
which was working perfectly well is doing strange thing. Suddenly I
can't input data into any of the fields. I have checked all
the .enabled and .locked properties, the .AllowAdditions
and .AllowEdits

I have tried recompiling, compact and repair, even rebooted my PC.
What the flaming heck is going on?

Stapes

 

[John W. Vinson]

Hi

I have been working on a project for 6 weeks now. Suddenly, a form
which was working perfectly well is doing strange thing. Suddenly I
can't input data into any of the fields. I have checked all
the .enabled and .locked properties, the .AllowAdditions
and .AllowEdits

I have tried recompiling, compact and repair, even rebooted my PC.
What the flaming heck is going on?

Stapes

Typically this will be due to a problem, not with the form itself, but with
the query upon which it is based. Try opening the form in design view; view
its Properties; click the ... icon by the Recordsource property to open it in
query design view. Go to the query datasheet. Is this query updateable (does
it have a blank *> line at the bottom?) If not, post the SQL view of the query
here and/or search the Help for "updateable".

 

[Stapes]

Typically this will be due to a problem, not with the form itself, but with
the query upon which it is based. Try opening the form in design view; view
its Properties; click the ... icon by the Recordsource property to open itin
query design view. Go to the query datasheet. Is this query updateable (does
it have a blank *> line at the bottom?) If not, post the SQL view of the query
here and/or search the Help for "updateable".

My form is not based on a query, but a table. What is baffling me is
how it has just happend for no reason.

 

[Stapes]

Typically this will be due to a problem, not with the form itself, but with
the query upon which it is based. Try opening the form in design view; view
its Properties; click the ... icon by the Recordsource property to open itin
query design view. Go to the query datasheet. Is this query updateable (does
it have a blank *> line at the bottom?) If not, post the SQL view of the query
here and/or search the Help for "updateable".

Hey - I have just found a 'Locked:Yes" on my subforms properties.

 

[John W. Vinson]

Hey - I have just found a 'Locked:Yes" on my subforms properties.

That'll do it! Is that the only issue? Might you have set it unintentionally?
I've never heard of such a property switching on its own but I suppose it
could happen.