By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,476 Members | 889 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,476 IT Pros & Developers. It's quick & easy.

Unable to edit a sub form even though the controls are not locked

P: 5
Hi Guys,

I'm building a phone book application. The main form is used for searching for individuals and when you find the one you want their details are shown in a sub form. There are some details I want to be editable (is that really a word?). When I first built the app all of the tables were inside the Access2003 .mdb file and I was able to edit info in the subform. I've now moved the tables into an SQL Server 2000 database (so I'm using Access as the front end and SQL Server as the backend) with the result that I can't make any edits in the subform. If I open the subform on its own I can edit it, likewise with the query I'm using to populate the form. I have no code in either the main form or the subform which locks the subform or any of the controls on it. Does anyone have any ideas about why this is happening?

Thanks,
Brian
Aug 9 '07 #1
Share this Question
Share on Google+
1 Reply


P: 5
Sorry guys, I've just had one of those 'Doh!' moments. I had the 'Locked' property for the subform set to yes. I don't remember doing it, but that means nothing when you have the memory of a goldfish.
Aug 9 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.