asked on

subform problem

I've set up a query which includes the totals row and then have connected it to a form. I then want to place a subform on this form which will have its recordsource from another query but with refers to the active form ie. [forms]![frmQualityApack]![proj_eng] which will then show associated information. I get the following error
You can't use a pass through query or non fixed column crossquery as a record source for a subform or subreport.
Before you bind the subform or subreport to a crosstab query, set the query columnheadings property.
any ideas..probably needs more info

Cheers

Scott

Poddy

is the query a crosstab query?

if so, do what it says ! :)

scottsanpedro

ASKER

No its not a crosstab query...I've only used the totals row in a normal query

Belz

Is it a pass-through query? If so your probably sending it a variable name or form variable. Pass-through queries must have a value passed in it not a variable.

scottsanpedro

ASKER

its not a pass through query either...all it is is a normal query with the total row inserted ie click view then totals,
it doesn't require headings as it not a crosstab query...
I'm trying to add a subform to show related records to the query.
To explain more...the original query shows the amount of sites a person engineers along with figures such as total hours per week assigned, actual hours worked and percentages..this then translates to a form and is proving no problem..the error occurs when i trying to add the subform...the error also occurs when i put [enter week number] on a datepart field..it doesn't allow the user to input the week, it works ok on running the query but not through the form...hope this explains a bit better

scott

ASKER CERTIFIED SOLUTION

24680148

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

scottsanpedro

ASKER

I'll go with that

Thanks again

Scott