Display contents of XTab Query in Form

W

WSF

Access97
Is there a way I can display the content of a CrossTab Query in a form?
I query data that can produce different date row headings so cannot display
with fixed field headings in a form or report.
The row headings are in 6-month lots - MonthYear (mm-yyyy) format - which
can vary depending on the data pulled.
I would like to display a snapshot of the data (eg in a pop-up form) for the
operator for visual information purposes only.
Thanks in advance.

WSF
 
A

Allen Browne

Not a simple solution, but you could use the Open event of the form to run
the query, discover the column headings you need, and then assign the
ControlSource of your various text boxes to the relevent heading names.
 
Top