limit display of data on continuous form by date

[Anne]

I am drawing a complete blank. I want to be able to limit the display of data
on a continuous form which is used for data entry by date.

I want to be able to display data by start date and end date, or start date
and no end date, just like one would for a report.

 

[John W. Vinson]

I am drawing a complete blank. I want to be able to limit the display of data
on a continuous form which is used for data entry by date.

I want to be able to display data by start date and end date, or start date
and no end date, just like one would for a report.

Base the form on a Query with appropriate date criteria, e.g.

BETWEEN [forms].[yourformname].[txtStartDate] AND
[forms].[yourformname].[txtEndDate]

Be sure the textboxes are unbound (nothing in their Control Source).

 

[Anne]

Thank you. I got this to work.

What I also need is to be able to have a start date and no end date and to
be able to clear the dates and show all.

I am drawing a complete blank. I want to be able to limit the display of data
on a continuous form which is used for data entry by date.

I want to be able to display data by start date and end date, or start date
and no end date, just like one would for a report.

Base the form on a Query with appropriate date criteria, e.g.

BETWEEN [forms].[yourformname].[txtStartDate] AND
[forms].[yourformname].[txtEndDate]

Be sure the textboxes are unbound (nothing in their Control Source).

 

[John W. Vinson]

Thank you. I got this to work.

What I also need is to be able to have a start date and no end date and to
be able to clear the dates and show all.

I should have posted the "long form": a criterion of

= NZ([forms].[yourformname].[txtStartDate], #1/1/100#) AND < DateAdd("d", 1, NZ( [forms].[yourformname].[txtEndDate], #12/30/9999#))

will cover all eventualities, including returning records where there is a
time portion.

 

[Anne]

That was exactly what I needed. Thank you

Thank you. I got this to work.

What I also need is to be able to have a start date and no end date and to
be able to clear the dates and show all.

I should have posted the "long form": a criterion of

= NZ([forms].[yourformname].[txtStartDate], #1/1/100#) AND < DateAdd("d", 1, NZ( [forms].[yourformname].[txtEndDate], #12/30/9999#))

will cover all eventualities, including returning records where there is a
time portion.