Can't enter data in form?

[Tony Williams]

I have a subform that is based on a query but when I open it I can't enter
or edit any data. The Recordset Type is set to Dynaset (Inconsistent
Updates), the Allow Edits, Additions and Deletions are all set to Yes and
the Data Entry is set to No.
can anyone point me in the right direction as to what else to look for?
Thanks
Tony

 

[Allen Browne]

Try changing the RecordsetType to Dynaset, i.e. not Dynaset (Inconsistent
Updates.)

 

[Tony Williams]

Thanks Alan that did it!
Tony

Try changing the RecordsetType to Dynaset, i.e. not Dynaset (Inconsistent
Updates.)

 

[kul]

But, what if I've got all these conditions, my data is gone missing?? (as I
have the forms created based on some names and addresses). If I have the Data
Entry set as No, there I can get back my info.. What should I do??

 

[Allen Browne]

But, what if I've got all these conditions, my data is gone missing??
(as I have the forms created based on some names and addresses).

If I have the Data Entry set as No, there I can get back my info.
What should I do??

Set Data Entry to No.

 

[kul]

Thanks for your reply Allen.

I get back the info at the MainForm. However, when I try to edit the info at
the SubForm, it keeps saying that "This property is read-only and can't be
set". What can I do now??

kul

 

[Allen Browne]

Set the property in design view, and save the form.

If you get this error when you change the values in the Properties sheet in
design view, I don't know what's going on.

 

[kul]

Oh Allen,

Thanks very much for your reply...
My trouble is:
At Design view, I've set Data Entry of the MainForm as "No", then I can get
back my info as you have mentioned. That's good. However, I can't add/edit
anything at the SubForm when I would like to do so at Form View. The message
"This property is read-only and can't be set" came out by the time I add/edit
at the SubForm, which stops me from doing anything about it.

No matter if I set the "Date Entry" to Yes or No, the same message keeps
coming out. Did I have anything wrong at the setting?? Pls help.

Cheers,
kul

 

[Allen Browne]

Kul, the goal posts keep changing here.
Whatever I say, the question morphs into something else.
I can't help.

 

[kul]

Thanks Allen.. That's okay..