Can't Open form with button

[chrisd49]

Hi All
I have a button which 'Opens@ a form based on a query. The first time I open the form this way all is OK and I can see all the records. If I close and try to reopen the form using the button I get an error message 'the table is already opened exclusively by another user, or is already open through the user interface and cannot be mamipulated programmatically'
Any ideas on this one fairly quickly if possible.
Cheers
Chris

 

[rio]

Maybe u don't close the table properly or maybe the table just minimize not close. Please check this.
Why don't u just used the command button with hyperlink.

 

[boblarson]

Post the code that you are using.