Query Error in List Box

[MattBaldry]

Hi All,

I have generated a query that filters from options of a form. When I open the form, the list box posts the below error.

But if I open the query itself, it shows the data and no error. Just won't display it in the list box.

I have 3 check boxes for the dates Created Date, Sent Date and Approved Date.

If the SentDate check box is ticked, I only want to see records with a date in this field.

This works fine opening the query to view (form open in the background), but the form itself gives the expression error....

Has anyone seen this before?

~Matt

 

[theDBguy]

Maybe the error is coming from somewhere else? Just a thought...

 

[MattBaldry]

Maybe the error is coming from somewhere else? Just a thought...

Ignore me, I have figured it out. I had the wrong expression on the listbox requery after box checked. Been a long day.

~Matt