Use a SQL statement to open form

[vonoventwin]

I'm trying to write a small SQL query that will allow me to open a form only with that person records. This is in Access 2003. The error I'm getting is a syntax error in the query

' Dim variables used
               Dim stDocName As String
               Dim stLinkCriteria As String
               ' Form name is 1486
                stDocName = "1486"
               ' Find out who is selected in the Employee combo box and make SUPER (text box on 1486) equal to that person (so it will filter records by the person)
                stLinkCriteria = "[SUPER]=" & "'" & Me.cboEmployee & "'"
                ' Create query that selects only the records of that person
                sSQL = "SELECT * FROM 1486 WHERE stLinkCriteria"
 
                ' Open the form
                DoCmd.OpenForm stDocName, , , sSQL

[dannymking]

I'm presuming that 1486 is the name of the form.. you cannot perform SQL against a form.. if 1486 is the table then what does the value in cboEmployee return.. is this a string value or numeric?

[vonoventwin]

I'm presuming that 1486 is the name of the form.. you cannot perform SQL against a form.. if 1486 is the table then what does the value in cboEmployee return.. is this a string value or numeric?

It returns a string (John Doe), then I want the form to open with only the records that have the SUPER (feild name) of John Doe..

[si_the_geek]

Try putting the value of the variable into the string, rather than the variable name

sSQL = "SELECT * FROM 1486 WHERE " & stLinkCriteria

[dannymking]

Your error is here..

' Open the form
DoCmd.OpenForm stDocName, , , sSQL

You are trying to open the form using the full SQL as the open argument.. Try just sending "[Super]=" & stLinkCriteria

Or open the form in design view set the recordsource to the SQL, save and close it and then open the form normally