Query Error in List Box (1 Viewer)

MattBaldry

Self Taught, Learn from the Forums
Local time
Today, 08:25
Joined
Feb 5, 2019
Messages
293
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.

1710341866524.png


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



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
 

Attachments

  • 1710341888059.png
    1710341888059.png
    7.7 KB · Views: 14

theDBguy

I’m here to help
Staff member
Local time
Today, 00:25
Joined
Oct 29, 2018
Messages
21,473
Maybe the error is coming from somewhere else? Just a thought...
 

MattBaldry

Self Taught, Learn from the Forums
Local time
Today, 08:25
Joined
Feb 5, 2019
Messages
293
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
 

Users who are viewing this thread

Top Bottom