Search results

Figured it out. Had to set it to integer and adjust the quotes to compare [ENCS Lead to the integer. Thanks for your help.

The field [ENCS Lead] on the report has a bound column of ID, but displays the name. I setup my combobox to have the name and id, but use the ID as the bound column for the selection criteria against the [ENCS Lead] column in the report. So I think I'm messed up on the data types. See...

Here is the result from your suggestion. I get the same error. myVariable value is "Jim Quinton" WhereString value is "[ENCS Lead] = 'Jim Quinton'"

Thanks for your assistance. However, I get a "datatype mismatch in criteria expression" error on the openreport command. The where statement is, WhereString = " [ENCS Lead] = """ & myvariable & """" I have a watch set and it shows the following myvariable value is "Jim Quinton" WhereString...

I'm not 100% clear on the syntax structure of using quotes (single/double) and & and # for string formatting. I figured out my first problem though, I was missing some quotes. However, I have another formatting problem with the following line out of the code below WhereString = " ENCS...

I have a similar problem. Refer to the code below. What happens is that while my variables contain the correct data, the WhereString is ignored by the DoCmd.OpenReport action. The DoCmd action always presents a dialog box where I can enter a value, then the report is fine. Is there something...