filter a combo box row source by date in a group by row source

[Ruegen]

I have a groupby row source so I can't add the dates d1, d2 d3 to a combo box row source

normally I could do a d1 criteria of a text date field on the main form however I have 3 dates on the same record that need to be filtered.

so if date 1 or 2 or 3 meets textbox date

show in combo box

I was wondering if you can do an after update on the textbox with the date that will filter the row source?



something like this however currently there is no record with all three fields with this date and I don't want records showing if they are null

[Ruegen]

Attachment 14557

this seems... to work?