Need to pull group/sort value into VBA 1

[Quintios]

I have a report in which I want to stuff a subreport, however, the subreport is based on a query that is dependent on the value used for grouping the main report.

How can I get this value?

The main report consists of several subereports; unfortunately, one of the subreports is quite complicated, so I'm going to have to create the information for it via VBA code, creating a temporary table and then basing a crosstab report off of that. Anyway...

When the main report runs, it's grouping is based off of one value only, called 'Sequence'. How do I capture the current value of 'Sequence' and then use it in VBA in the report?

Man thanks... I'm going to crosspost this in the VBA section as well.

thx!

Q-

 

[dhookom]

You can try something like:
Me.Parent.txtSequence
where txtSequence is a text box containing the sequence value.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.