Connecting Tech Pros Worldwide Help | Site Map

grouping in forms access 2003

 
LinkBack Thread Tools Search this Thread
  #1  
Old November 9th, 2007, 10:25 PM
nina
Guest
 
Posts: n/a
Default grouping in forms access 2003

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



  #2  
Old November 10th, 2007, 03:55 AM
Allen Browne
Guest
 
Posts: n/a
Default 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
  #3  
Old November 10th, 2007, 06:35 AM
JHB
Guest
 
Posts: n/a
Default 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
>
>

 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 220,662 network members.