Filtering due date using form

[Kaybaj]

Hi,
Please i got stucked in this, i have a table with many columns.
one of the columns contains due date for payments. what i want it is for a form to open displaying/listing the due paymets alone when i click a command button.
I'll appreciate this.

Thanka

 

[vbaInet]

Payments with a Due Date less than or equal to today's date? Here:

<=Date()

 

[Kaybaj]

Thanks, but it still not working keeps telling me "datatype mismatch"
But d duedate column is a calculated field.

 

[vbaInet]

Alright, so what's the calculation? And are you sure the calculation is returning a Date?

 

[Kaybaj]

Thanks, I finally got it to work, it was my filtering method that was wrong.

 

[vbaInet]

Good job Kaybaj!