Search results

I am using the where condition when opening a report. I am using referring to the control in order to pass the criteria, but get a msg that says incorrect data type. It is a text field with info like this (00166), but it works fine when I hard code it. Example below. docmd.open report ...

In addition, learn the dlookup function. It is very useful, and allows you to get information from sources other than your record sources.