Filter Split Form by Date Using Unbound Text Box

[P5C768]

I have a split form that is bound to a union query that consolidates data from 5 tables. Right now, when the split form is open, it shows all data. I would like users to be able to use a unbound start date (and eventually end date) text box I have created to filter the form by a date field in the table. However, when I run my embedded macro, the filter returns no results. I would like to keep the code in the embedded macro if possible but could switch to VBA if needed. Here is the macro code I am currently using:





Any help is greatly appreciated! Thanks!

[June7]

Are you aware a UNION query is not editable? Purpose of form is to just view records and to open another form or report for selected record?

I don't use macros and I can't readily see anything wrong with what you show - it looks okay.

Maybe create a VBA procedure just as a test to see if the filter setting will work and if successful go back and try to replicate in macro.

[P5C768]

Yes, purpose is to view records and open report. VBA works, just can't get the macro to work, not really sure why.

[June7]

I never use Filter property of report. I use the WHERE CONDITION argument of DoCmd.OpenReport. I think WHERE CONDITION can be replicated in macro.