Select statement

[shaz123]

Hi this is a quick one,
i wanted to add this line of code to the select statement, however im getting this error message.

"Expected list or Seperator )"

 Set rs = db.OpenRecordset("SELECT * From tbl_Delupdate WHERE tbl_Delupdate.[Cylinder Barcode Label]= '" & stringy1 & "' AND _ 
tbl_Delupdate.[Works Order Number] = person.Text And [D Status] = 'Delivered' ")

I think my mistake is "tbl_Delupdate.[Works Order Number] = person.Text "
i am trying to refer to a listbox on the form.

Any ideas
How would be able to see what the result of the select statment is

 

[straybullet]

Set rs = db.OpenRecordset("SELECT * From tbl_Delupdate WHERE tbl_Delupdate.[Cylinder Barcode Label]= '" & stringy1 & "' AND &
_
tbl_Delupdate.[Works Order Number] = person.Text And [D Status] = 'Delivered' ")

Let them hate - so long as they fear... Lucius Accius

 

[TheAceMan1]

shaz123 . . .

[blue]person.text should have single quotes[/blue] incorperated . . . yes?

See Ya! . . . . . .