Type Mismatch of another kind

[mdweezer]

I'm trying to pull in data for a report by using a form, then passing values from that form to the report and using a Me.RecordSource to display the report.

The value passes to the report fine and I can hold my mouse over it and see it's value. The following line screws up and gives me the type mismatch error:

qry = qry * "WHERE (((TBL_Items.Item)=" & TitleValue & "));"

TBL_Items.Item is a text field and TitleValue contains the string that I would like to compare against the Item field.

What would be the correct way so it would return any record where TBL_Items.Item contains any of the text in TitleValue

Thanks!

 

[mdweezer]

Sorry folks...

I'm an idiot Instead of using concatanating the string with an "&", as you can see I typed a "*" on accident...

Good thing Fridays are only half days where I work!

Yikes...

 

[Robotron]

Try it this way:

qry = qry * "WHERE (((TBL_Items.Item)= '" & TitleValue & "'));"

If the data in TitleValue is a string, you will need to use the single quote around it.

Phil Edwards