Filter form Records from combo?

[CutAndPaste]

Hi,

I've got a form which shows data from an underlying query. One of the fields [EndDate] can either have a date in or not. I want to be able to select and display records with or without an [EndDate] from a combo box on the form - the afterupdate event on the combo would presumably need to requery the datasource of the form. I've been trying to put in "Is Null" and "Not Null" in the combo but this doesn't seem to work.

How can I do this?

tx

Simon

 

[dcx693]

Are you setting the rowsource of the combo box to "Is Null";"Not Null" ? If so, then what is your code for requerying the datasource? You'd need either an IIf function in your source query, or a SQL clause to feed into the form recordsource if you're doing it that way.