Pass-through query error "non-fixed-columns" for subrebort/subform

[oddbec]

Hi!

We have an old application (as an Access Front-end to a sql-server) that I need to make changes to.

I have set up a pass-through query to the SQL-server and it works flawlessly, and I have also tied it up to the sub-form, which again is attached to the main form.

When I execute the sub-form independently it shows the data just as I would expect, but whenever I try to open the main form containing the sub-form, I get an error saying:

'You can't use a pass-through query or a non-fixed-column cross tab query as a record source for a subform or subreport.'

I've been looking everywhere for a solution, and everyone suggests I have to set up the columns properly - but I'm unable to find out where I can set these. I've read numerous posts regarding this, but I'm still not able to locate the "ColumnHeadings" referred to.

I've also found references to "child link" etc that needs to be disconnected for this to work, but I don't know how to do this, and I'm not even sure that's the solution.

I would have used a regular query if it wasn't for a specific masking function that we have implemented on the Sql Server, hence the pass-through query.

Can anyone give me a few pointers?

Thanks in advance.

Best regards,

Beck

 

[oddbec]

I've found a solution to this part.

I have created a function that returns a recordset, and then I bind this recordset to the recordset of the form.