grouping in forms access 2003

grouping in forms access 2003

am 10.11.2007 00:38:24 von nina

is there a way to group records in forms in 2003 version
ie. i have number of records with date and would like to see it in this way
on a form

sep 2007
rec1
rec2
rec4
..
..
..

oct 2007
rec1
rec2
....

i know haw to do it in a report, but is there a way to do it in form?

tnx

Re: grouping in forms access 2003

am 10.11.2007 05:45:31 von Allen Browne

No: a continuous form cannot display data like that.

One workaround might be to place a combo on the main form to choose the
month and year, and then filter the subform to show only the matching
records.

I guess you could use 3 subforms, where the middle one shows the selected
month, the upper one the previous month, and the last one the next month.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"nina" wrote in message
news:fh2pmi$ioc$1@ss408.t-com.hr...
> is there a way to group records in forms in 2003 version
> ie. i have number of records with date and would like to see it in this
> way on a form
>
> sep 2007
> rec1
> rec2
> rec4
> .
> .
> .
>
> oct 2007
> rec1
> rec2
> ...
>
> i know haw to do it in a report, but is there a way to do it in form?
>
> tnx

Re: grouping in forms access 2003

am 10.11.2007 08:29:30 von JHB

Only if you use a treeview

"nina" skrev i en meddelelse
news:fh2pmi$ioc$1@ss408.t-com.hr...
> is there a way to group records in forms in 2003 version
> ie. i have number of records with date and would like to see it in this
way
> on a form
>
> sep 2007
> rec1
> rec2
> rec4
> .
> .
> .
>
> oct 2007
> rec1
> rec2
> ...
>
> i know haw to do it in a report, but is there a way to do it in form?
>
> tnx
>
>