Connecting Tech Pros Worldwide Help | Site Map

grouping in forms access 2003

nina
Guest
 
Posts: n/a
#1: Nov 9 '07
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


Allen Browne
Guest
 
Posts: n/a
#2: Nov 10 '07

re: grouping in forms access 2003


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" <nina@nina.comwrote in message
news:fh2pmi$ioc$1@ss408.t-com.hr...
Quote:
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
JHB
Guest
 
Posts: n/a
#3: Nov 10 '07

re: grouping in forms access 2003


Only if you use a treeview

"nina" <nina@nina.comskrev i en meddelelse
news:fh2pmi$ioc$1@ss408.t-com.hr...
Quote:
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
Quote:
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
>
>

Closed Thread


Similar Microsoft Access / VBA bytes