anorakgirl
Programmer
Hi,
I have written a union query, which I am able to use as the record source for a form.
However if I make this form into a subform on another form, even without linking child/master fields, I get the error:
However, this query is definitely not a pass-through query, and the columns are fixed, and the query does not have a column headings property. Is is possible to do this - all I want to do is display the union query results within another form!
Thanks,
Tamsin
~ ~
I have written a union query, which I am able to use as the record source for a form.
However if I make this form into a subform on another form, even without linking child/master fields, I get the error:
Code:
you can't use a pass-through query or a non fixed column query as a record source for a subform or report
Before you bind the subform or subreport to a crosstab query, set the query's Column Heading property
However, this query is definitely not a pass-through query, and the columns are fixed, and the query does not have a column headings property. Is is possible to do this - all I want to do is display the union query results within another form!
Thanks,
Tamsin
~ ~