Whats wrong with this SQL Satement?

[Guest_imported]

stLinkCriteria = "[Orders.Company]=" & "'" & Me![Company] & "'" & " [Date Ordered]=" & "'" & Me![Date Ordered] & "'"

 

[RoyVidar]

Hi

I think you need a separator "," or ";" between the two fields, and if the dates in your statement are dateformat, you need to change to:

" [Date Ordered]=" & "#" & Me![Date Ordered] & "#"

Good luck, Roy-Vidar

 

[fmbpcsup]

If you are trying to use the values from the form text boxes then it should look like:

stLinkCriteria = "[Orders.Company]=" & Me![Company] & " [Date Ordered]= #" & Me![Date Ordered] & "#"

(assuming you put this all on one line)
(also assuming that Date Ordered is a date type that's why I suggested the #'s