var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: grouping on forms
Does anyone know a way to sort and group records on a form in the same way that you can on a report?
I want to create a continuous form that has headers grouped by date.
You can't group on a form as you can on a report. Base your form on a query which takes the date as it's criteria.
You can "Sort of" make it work like a report.
You need a Form/subform relationship.
In the main form you need it's recordsource to be a group by query with the date as your criteria.
In the subform you need the recordsource to be the ungrouped detail.
then the Parent/Child proerties of the form subform are the Date.
ie. 1 date in the parent shows multiple details for that selected date.
Great Idea, it might just work!
Thanks for your help.