Len,

You may be able to launch the query but can you edit it? It sounds like you
can't. Fixing the query should fix your issue.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

".Len B" wrote in message
...
I have a subform whose Record Source is a Select Query. It will not
permit data entry either from the parent form or from the subform itself.
The status bar doesn't give an error message.

AllowAdditions and DataEntry are 'Yes'. Dynaset RecordType, no
RecordLocks. The AllowEdits and AllowDeletions were 'No' but temporarily
changing them to 'Yes' didn't help. Some of the fields are locked but
enabled (eg Date (=Now) and WinUserName) but most are not locked. I have
gone through all the form's properties looking for something without
success.

I can launch the query in the query builder using [...] on RecordSource
item, switch to data view and add new records without issue.

Now I'm asking can anyone point me at somewhere to look, please?

--
Len
__________________________________________________ ____
remove nothing for valid email address.