Won't let me enter data.

[andrew3254]

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?

 

[Allen Browne]

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.

 

[andrew3254]

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.