Hi all,

I am looking to try and replicate the 'group by' functionality of reports in a continuous subform - without much success so far it has to be said...

The main form is a single form containing customers.
The subform is a continuous form containing reservations.
They are linked by one customer to many reservations on CustID.
Each reservation can have one or more rooms, also linked by one reservation to many rooms on ResID, so the subform will display a record for each room within a reservation.

To simulate the grouping, what I'm trying to achieve is to group the records by date. So if three records in a row all belong to the one reservation, I only want to see the date displayed next to the first record and nothing next to records 2 and 3.

Is it possible then to hide a control (in this case txtDate) based on the value of the control above it, either on the load or requery after filter of continuous forms?

Or alternatively is there another way to achieve a similar 'grouping' effect?

Many thanks!
PeregrinTook