filter form and continuous form with pages

[inspector-71]

Hi all,

I have a couple of questions about my form (see below)

1. I want to apply a filter to show only the open records (defined by the closed checkbox). what is the best way to do this?
2. How can I make the form non-scrollable so that when the page is full, I need to move to a different page (rather than scroll down)

Many Thanks,

 

[JamesMcS]

1. Filter "WHERE [Closed]=False" - assuming that's the name of the field the checkbox is bound to of course.

2. Can you have pages on forms? I'm not sure but I don't think so. You might consider changing it to a subreport, that's the only way I can think of paginating it...

 

[inspector-71]

ok, the closed filter now works a treat. Thanks.

I also want to filter when due date is > todays date i.e an overdue filter.

I'm not having much success with this using docmd.applyfiler "[due date]>..........not sure of syntax
"[due date]>date" asks for an input for date
"[due date]>" & date doesn't filter correctly

help greatly appreciated

 

[inspector-71]

it's ok, i just didn't know the syntax for using dates.

DoCmd.ApplyFilter , "[due date]<#" & Date & "#"

worked fine

 

[JamesMcS]

Excellent, glad it worked!