How do I change the record source of a subform

[cliftonx]

I'm trying to change the record source of a subform. I'm getting for following error:

The following is the code I use to generate the error:

 

[theDBguy]

Maybe you could try it this way instead?

Forms!frmiimain.frmDevsWithPartSpecs.Form.Recordset = rst

(untested)

PS. I think the error message simply means you're using a dot notation outside of your With block. In other words, you already had the End With line before the line with .sql in it.

 

[cliftonx]

Maybe you could try it this way instead?

Forms!frmiimain.frmDevsWithPartSpecs.Form.Recordset = rst

(untested)

PS. I think the error message simply means you're using a dot notation outside of your With block. In other words, you already had the End With line before the line with .sql in it.

I tried the above code and now I get the following error:

Here is the new code:

 

[Gasman]

Can't you just qualify the sql with qdfpass ?
Qdfpass.sql

 

[CJ_London]

@cliftonx - you need to read the second part of DBG's post

 

[MarkK]

You may need to use Set....

Set Forms!frmiimain.frmDevsWithPartSpecs.Form.Recordset = rst

... to do an assignment with an object type.

 

[cliftonx]

Maybe you could try it this way instead?

Forms!frmiimain.frmDevsWithPartSpecs.Form.Recordset = rst

(untested)

PS. I think the error message simply means you're using a dot notation outside of your With block. In other words, you already had the End With line before the line with .sql in it.

Thank you. That solved the problem. I was using the dot notation outside the With block.

 

[theDBguy]

Thank you. That solved the problem. I was using the dot notation outside the With block.

Hi. Glad to hear you got it sorted out. Good luck with your project.