Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Record Source Error Using Access 2003

Status
Not open for further replies.

roaml

Technical User
Feb 19, 2002
264
US
Hello,

I am trying to open a form from another form that uses the same record source table. I receive the following error message when clicking on the button.

<BEGIN ERROR>

The table ‘network_wo’ is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically.

<END ERROR>

Here is the code I am trying to use:

<BEGIN CODE>

Private Sub Network_Details_Click()
On Error GoTo Err_Network_Details_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = " network_details_form"

stLinkCriteria = "[ni_ID]=" & Me![ni_ID]
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_Network_Details_Click:
Exit Sub

Err_Network_Details_Click:
MsgBox Err.description
Resume Exit_Network_Details_Click

End Sub

<END CODE>

Thank you sooo much!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top