Display contents of XTab Query in Form

  • Thread starter Thread starter WSF
  • Start date Start date
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
 
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.
 
Back
Top