 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / March 2008Can't enter data in form?
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 Try changing the RecordsetType to Dynaset, i.e. not Dynaset (Inconsistent Updates.)  SignatureAllen 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 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 Alan that did it! Tony > Try changing the RecordsetType to Dynaset, i.e. not Dynaset (Inconsistent > Updates.) [quoted text clipped - 4 lines] >>the Data Entry is set to No. >> can anyone point me in the right direction as to what else to look for? 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?? > Try changing the RecordsetType to Dynaset, i.e. not Dynaset (Inconsistent > Updates.) [quoted text clipped - 4 lines] > >the Data Entry is set to No. > > can anyone point me in the right direction as to what else to look for? > 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. SignatureAllen 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. 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 > > 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). [quoted text clipped - 3 lines] > > Set Data Entry to No. 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. SignatureAllen 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 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?? 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 > Set the property in design view, and save the form. > [quoted text clipped - 5 lines] > > the SubForm, it keeps saying that "This property is read-only and can't be > > set". What can I do now?? Kul, the goal posts keep changing here. Whatever I say, the question morphs into something else. I can't help. Thanks Allen.. That's okay.. > Kul, the goal posts keep changing here. > Whatever I say, the question morphs into something else. > I can't help. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.