Reference to query Property ???

  • Thread starter Thread starter Ryan
  • Start date Start date
R

Ryan

I would like to set the Column Headings property of a
crosstab query from VBA script on a form. I don't know
all of the object hierarchy and can't reference the
property.

This is what I have tried:

Application.CurrentData.AllQueries("Time Admin
CrossTab").ColumnHeadings = ColumnString

CurrentDb.QueryDefs("Time Admin Crosstab").ColumnHeadings
= ColumnString

Neither works since .ColumnHeadings isn't a property of
either ... I just don't know where to reference it. Can
someone tell me how to do what I am trying to do.

Thanks, Ryan
 
Back
Top