Form Design.

[kpryan]

Hi All,
Could I have some help with this one please. I Want to design a form that looks similar to a report using the sorting and grouping.
I have a continuous form with many records. I can sort them by date and a reference no.
What I want to do is to be able to sort by date and force a new page by date so that only those records will show by their date. I have tried in the detail section setting the Force New page in the properties but it does not seem to work. I must be missing a setting somewhere... I could use a select query and input a date, but did not want to go this way.
Many thanks,

Ken

 

[Kiwiman]

One way is to use a query

Select YourDate from YourTable group By YourDate

, and make this the record Source of your MainForm.

The add your existing form as a subform of this new main form. linking by YourDate...

Take it Easy
Man with one chopstick go hungry