Changing record source of SubForm - Help

[nxqviet]

Hi all,

I need help in changing a record source of a sub form.

I used this code

========================Code====================
Dim varName As Variant
varName = SessionID.Value

Dim stRecordSourceSQL As String
stRecordSourceSQL = "SELECT [" & varName & "].ID, [" & varName
& "].ServiceName, [" & varName & "].Price FROM " & varName & ";"

Forms!frmAsgnPrice_EditPrices!frmAsgnPrice_EditPricesSubForm.Form.RecordSource
= stRecordSourceSQL

========================End=====================

The form containing this sub form is open when this code is executed.
It keep saying that "the Object is closed or Does not exist". How do I
change this?

Thanks,

V_

 

[Tom Wickerath]

Try this:

Me!ContainterName.Form.RecordSource = stRecordSourceSQL

where "ContainterName" is the name of the subform object on your form. It
may or may not have the same name as the subform itself. It is not the same
as the subform; it's the object that contains the subform.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Tom Wickerath]

And if Tom could spell correctly, he would have used "ContainerName" instead
of ContainterName. Oh well, at least I was consistent in my misspelling!


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________