Opening Two Forms Based On Same Table

[kh59743]

Form #1 allows me to modify/add data to records in Table A.

Form #2 is restricted to displaying (no edit, add, delete capabilities) information from a query that is based on Table A.

I need to find a way to open an instance of Form #2 while in Form #1, but I keep getting the following message...

"The table 'TableA' is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically."

Any suggestions for how I can get around this?

The data I want to display in Form #2 is not linked to the record being displayed in Form #1, so a subform will not work.

Thanks in advance!

 

[ssoltic]

Its not nessesery for subforms to be linked.

 

[kh59743]

I still get the following error message when I try an unlinked subform.

"The table 'TableA' is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically."