Querying a Sharepoint linked table in MS Access via VBA

[codeliftsleep]

I have 3 sharepoint linked tables in Access and I have a form that users can enter an employee number or employee name. I then want to query one of the tables to find the information and bring it back, but I can't seem to get it working.

The linked table shows up as Employee_Table Client File

I thought I should be able to use DoCmd.RunSQL = "SELECT Employee_Table[Employee #] WHERE Employee_Table[Employee #] = " & empSearchVal & " FROM Employee_Table;" Do I need to somehow include the Client File in the path as well?

However, I keep getting Run Time error 3075: Syntax Error(missing operator) in query expression.

Also once I get this working, I save it to a recordset to get the rows that returned correct?

Sorry for the basic questions, I am using this at work but am used to query SQL DB's from ASP.Net using C#, not VBA...little learning curve

 

[codeliftsleep]

Just in case...The Employee name or number is coming from the form data, they hit a search button and then it runs the macro to lookup the rows based on that info.