Grouping in a Form

[oakleaf8]

Is it possible to group in a form? As an example, look at Tek-Tips FAQ page:

http://www.tek-tips.com/faq.cfm?pid=702

It's records (the 'FAQs') are grouped by 'FAQ Category' (in the light blue band). All 'FAQs', all 'Categories' are shown.

I wish to create a form to do something very similar to this. It is not editing or adding fields in any table, just presenting a specific text data field that I wish to click on to view detailed record info, very similar to clicking on a 'FAQ Title' in the Tek-Tips FAQ page example. It's header will have filtering buttons.

Thanks!

 

[ZmrAbdulla]

Grouping(crating groups) on a form is not possible. You can filter the data. If you want the data show as FAQ are then why not a report?
See a sample of filtering here

http://www.fontstuff.com/downloads/index.htm#accessvba

named.
Access and SQL Part 6: Dynamic Reports


________________________________________________________
Zameer Abdulla
Help to find Missing people

 

[oakleaf8]

I have the filter already created. I prefer to keep the filter on the same object that I have the data. It's cleaner and a bit sexier.

Unless someone has an answer I'll keep the field I want to group on with the same line/record as the other data and sort on it. It just looks very redundant and it would seem to me there would be an easy way to do this.

Thanks.

 

[ZmrAbdulla]

A sample is here.

http://www.helenfeddema.com/Files/Modified_Northwind_2000.zip

or
A TreeView-ListView combination can give you the result.

or else
Use some third party controls that have ability to group the records


________________________________________________________
Zameer Abdulla
Help to find Missing people

 

[oakleaf8]

That's currently how I have the form set up, but not what I'm looking to do Zameer, that's why the post. I guess the answer is "You can't group in any way in forms".

Another interesting thing is that in Forms "acNormal" view it appears that Can Grow even when set to "Yes" still does not allow fields to grow vertically. It allows it in "acPreview" though, but this does me no good as I have buttons in the form.

Oh well, unless I'm missing something guess I'm out of luck. Thanks.