G
Guest
Hi All,
I have a combo box with a record set based on a table tblJobNumbers. What I
want to do is to be able to filter this recordset by a date field
'jnFinishDate' so that you can show either all job records or records without
a date field (null) and with a date within the last six months. I want to be
able to filter from a form so that it changes the combo box list accordingly.
I hope this makes sense.
Thanks
Matt
I have a combo box with a record set based on a table tblJobNumbers. What I
want to do is to be able to filter this recordset by a date field
'jnFinishDate' so that you can show either all job records or records without
a date field (null) and with a date within the last six months. I want to be
able to filter from a form so that it changes the combo box list accordingly.
I hope this makes sense.
Thanks
Matt