Formula in bound box

[Mikk]

I have a form that is based upon a query that has 3000
records. Many of these records possess the same date
(eventually all dates in the year are present). However,
I only want the user to scroll down one date at a time,
thus seeing 365 total pages in the form. I realize that
the underlying query could be summed (grouped) but then I
would limit my data in other ways. My logic is to somehow
create an "internal group command" in the date field. Can
this be done?

 

[Dirk Goldgar]

I have a form that is based upon a query that has 3000
records. Many of these records possess the same date
(eventually all dates in the year are present). However,
I only want the user to scroll down one date at a time,
thus seeing 365 total pages in the form. I realize that
the underlying query could be summed (grouped) but then I
would limit my data in other ways. My logic is to somehow
create an "internal group command" in the date field. Can
this be done?

I can't figure out how your mesage's subject relates to its content, so
I'll ignore the subject and address the content.

How about a main form/subform arrangement, with the main form either
unbound or based on a SELECT DISTINCT query that returns only the date
field, one record per date. If you do the latter, you have your
navigation from one date to the next built-in; if the former, paging
forward or backward by date would be accomplished by code that adds or
subtracts one day at a time to/from the "DateDisplayed" control on the
main form.

The subform would display the details, and would be linked to the
"DateDisplayed" control on the main form so that it shows only the
records for that date.