Can’t open table while editing.

[powersp68232]

I’ve noticed that when some users are entering information into a form that the corresponding table cannot be opened until the other user has saved or exited the form. Is there a way around this? What causes this?

 

[powersp68232]

https://ibb.co/miAb3J

Here is a link to what the form shows after someone starts to edit the entry. Only the entry being entered shows #deleted . All others show as normal. All users have there own copy of the front end and the form is set to row level locking.

 

[My Aswer Is This]

If your talking about a UserForm.
Open your UserForm like this:
UserForm1.Show Modeless

 

[My Aswer Is This]

Not sure what this means:

corresponding table cannot be opened​

How do you Open a Table?

 

[Joe4]

If your talking about a UserForm.
Open your UserForm like this:
UserForm1.Show Modeless

How do you Open a Table?

This is in the Microsoft Access forum, not the Excel Questions one.

 

[My Aswer Is This]

Oops.

This is in the Microsoft Access forum, not the Excel Questions one.

 

[Joe4]

Regarding the original question, have a look here: https://support.office.com/en-us/article/recordlocks-property-6ca29bbb-8824-4671-8087-97fe0568019a

 

[powersp68232]

I have RecordLocks=2 coded into VBA on form load.

 

[Joe4]

I notice for that option it says:

[FONT=wf_segoe-ui_normal]A [/FONT][FONT=wf_segoe-ui_normal]page[/FONT][FONT=wf_segoe-ui_normal] of records is locked as soon as any user starts editing any field in the record and stays locked until the user moves to another record.
[/FONT]

Does your form have one record per page, or multiple records per page?

 

[powersp68232]

Each form is only one record. The form while editing does stop others from editing the same record like it should.