My Application has suddenly started playing up

S

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
 
J

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
Click to expand...

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".
 
S

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".
Click to expand...

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

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".
Click to expand...

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

John W. Vinson

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

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.
 
Top