Display two subforms without gap/overlap

[PeteG]

Good morning,

Similar to a recent thread of mine, I have two subforms (continuous forms) that appear one underneath the other in the detail section of the parent form (single form view). The parent form is on a page of a tab control. What I am trying to do is to get the data within each subform to be displayed without any gap or without overlap, ie regardless of the number of rows that the first subform would contain, the next subform would display its' data immediately underneath it. I'm aware from the recent thread that I could programatically adjust the height of the detail section but I don't think I would have the same control over the positioning of subforms within the detail section?

Both subforms are bound to a table - the same table in fact. I decided on two forms instead of one because both forms have a slightly different filter on them to list a different subset of records and I want descriptive headings at the top of each set of records.

Given what I want to achieve, are there any other suggestions for what I should be doing, if the two sub form approach is not workable/best practice?

Thanks for any advice

 

[dhookom]

If the records don't require editing, I would suggest a union query and one subform rather than two.

Duane
Hook'D on Access
MS Access MVP

 

[PeteG]

Yes, I could do - but I think I would then lose the ability to add descriptive headings for each of the two sets of data. Well, I could do. I could add in to the query a row that describes the data but then I wouldn't be able to format that row to make it appear any different to the data around it.

Still, it's food for thought, thanks

 

[dhookom]

You can use conditional formatting to change individual rows.

Duane
Hook'D on Access
MS Access MVP

 

[PeteG]

Good idea, thanks. That is working well for what I'm trying to do