So I can't put a subform in a continuous form. Why is beyond me, but I have pretty much accepted it. I want to represent data in a form something like this:

Transaction Header Information
---Transaction Detail Information
---Transaction Detail Information
---Transaction Detail Information
Transaction Header Information
---Transaction Detail Information
Transaction Header Information
---Transaction Detail Information
---Transaction Detail Information
Transaction Header Information
Transaction Header Information

Each of the detail items refers to the header information above it. I want to be able to see headers in a continuous format. My requirement would be easily accomplished if I could put a subform in a continuous form. Since I can't do that, is there a good workaround?

Hi,

Probably not the answer you are looking for but you can do that in a Report.

Does it have to be a form?

Just my 2 cents...

I think it does need to be a form. I want to be able to update the data.

What's the underlying business need?

Do you really need to see all those transaction headers, or just a single one, with its detail (subform) records?

I don't HAVE to see all those headers, but it makes things easier for the user. If I did not want to see all those headers, I understand how to easily accomplish that.

You could use a single form with a subform to show the transaction detail records.

In the Form header, display a listbox with the information for the transaction header.
When the user clicks on a row in the listbox, change the Transaction record in the form (and the linked subform details should automatically update)

Thanks, John. That seems to be the best I can do. I pretty much did what you suggested except I put the transaction header information in its own continuous form subform, with a separate subform for the associated transaction detail.

Hi Thom,

Just in case you are interested, check out this previous post from Gord.

Hope that helps...