OK, now I have another question related to the MS dynamic crosstab report.
I followed their instructions (at support.microsoft.com), set up a form with unbound text boxes for my criteria, set up the forms!formname!controlname in the parameters and in the criteria on my xtab query.
Then I went through their whole rigamarole of Code and Event Procedures and such, putting in my own form names and such.
It's not working, however, and since I don't know much about this process, I can't figure out why. When I open the report I"m getting this message: Run-time error '2450': MS Access can't find the form 'WXReportFilter' referred to in a macro expresson or VB code.
The code to which it directs me is this:
Private Sub Report_Open(Cancel As Integer)
' Create underlying recordset for report using criteria entered in
' WxReportFilter form.
Dim intX As Integer
Dim qdf As QueryDef
Dim frm As Form
' Set database variable to current database.
Set dbsReport = CurrentDb
Set frm = Forms!WxReportFilter
' Open QueryDef object.
Set qdf = dbsReport.QueryDefs("[WX report query hours xtab test 3b]")
' Set parameters for query based on values entered
' in WXReportFilter form.
' Open Recordset object.
Set rstReport = qdf.OpenRecordset()
' Set a variable to hold number of columns in crosstab query.
intColumnCount = rstReport.Fields.Count
My form is called WxReportFilter, I named it that when I did "save" when I created it. I can't figure out within the form if there's another place where I'm supposed to name it so that it can be found.
Maybe I don't completely understand "controlname'?