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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Crosstab Query to Existing Table 0
Creating a Chart on form from selected data in query. 0
Help creating a search form in Access XP 0
DLookup in Continuous form 0
How to display zero value in blank fields of Cross Tab query 0
Inserting an Excel Worksheet into an Access form 4
How do I clear a form? 0
QBF & Query Malfunction 0

Top