Error 3044 - Invalid Path

[maggielea]

Hello, How do you check the path for the table links when you open the switchboard of an application? When my switchboard opens, I populate a label Caption with the Owner name and use a Dlookup. This produces an error 3044, "Invalid Path" when my client opens it. I'd like to put code in to trap this error and not run the Dlookup code if the path is invalid.

Thanks, Maggie

 

[CautionMP]

This is more error avoidance.

Coding from memory so it may need tweeking...

...
Dim strFilter As String, strPath As String
strFilter = "Name=""[i]LinkedTableName[/i]"""
strPath = DLookup("Database", "MSysObjects", strFilter)
If Dir$(strPath) <> "" Then
  'Update your caption here
End If
...

Hope this helps,
CMP


[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)