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

Form Locking

P: 1
Need some help please.

There are 4 tables in this database. Six controls on the form are related to the table Degree. The other controls on the form are related to the other three tables.

My problem with this form (which was working fine) is that when a new record is created the 6 controls that are from the Degree table are not editable. This occurs randomly with new records, so not all new records will have this problem.

The database is stored on a shared drive with 2 users accessing it.

db - Access 2003 - Default Open Mode = Shared - Default Record Locking = No Locks
os - WinXp Pro

Thank you.
Mar 12 '08 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 2.5K+
P: 2,545
Hi. Without seeing the SQL for the recordsource of your form it is impossible to say. Potentially there could be issues with the joined fields in the recordsource query, but this would just be a guess at present. To help you more we do need to see the SQL for your form's recordsource and know a bit more about the key fields and relationships between your tables.

Mar 15 '08 #2

Post your reply

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