Search / Find Button on Form (1 Viewer)

[worldcert]

Hello

I have a form with multiple tabs at the top. Each tab opens another area with fields all stored on the same table.

I added a find button and it generally works but this following error message sometimes pops up.

"The microsoft jet database engine stopped the process because you and another user are attempting to change the same data at the same time."

This is a multiple user database but we dont have this problem on any other page. Also we are not trying to change the data. Just find a record.

The find button searches all field in every tab. I have locked some tabs so the search does not search the fields.

Does anyone have any idea why the error message pops up? Thanks in advance.

 

[MarkK]

This error occurs if the current record in a form has pending edits, and you attempt to edit the same record in a different recordset. You can solve this by using Me.Refresh on the record in the form before initiating other routines that may also edit that record.