Won't let me enter data.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

andrew3254 - 05 Mar 2008 11:11 GMT

Hi,

I have a continuous form which has the data setting to allow edits and the
combo boxes set as enabled and not locked. I can view the pull down menu but
not select one of the options, neither can I enter anything in any of the
text boxes. They are all enabled and not locked, I have full permissions as
I am the administrator.

Anybody have any ideas?

Signature

Thank you in advance

Reply to this Message

Allen Browne - 05 Mar 2008 11:39 GMT

If this form is based on a query, open the query itself. Can you edit the
data there?

NO: For a list of possible reasons, see:
Why is my query read-only?
at:
http://allenbrowne.com/ser-61.html

YES: Check out the properties of the Form, particularly on the Data tab.
For example, RecordsetType should be Dynaset.
If if this form is a subform, the parent form's properties may have blocked
it.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> I have a continuous form which has the data setting to allow edits and the
> combo boxes set as enabled and not locked. I can view the pull down menu
[quoted text clipped - 3 lines]
> as
> I am the administrator.

Reply to this Message

andrew3254 - 05 Mar 2008 11:55 GMT

Hi, fixed it before your post. It was a read-only error.

I realised it was due to the SQL statement using a distinct statement.
Removed that and it worked fine.

Signature

Thank you

> If this form is based on a query, open the query itself. Can you edit the
> data there?
[quoted text clipped - 16 lines]
> > as
> > I am the administrator.

Reply to this Message