Form Locking

[Michael728]

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.

[Stewart Ross]

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.

-Stewart