Why this 2467 error?

[manning_news]

Using A2K. Have the following code in a form just before a subform is
requeried:

Select Case Me.cboEvaluations
Case "Ambulatory Medicine"
Me.subfrmEvaluations.SourceObject =
"subfrmEvals_AmbulatoryMedicine"
{...snipped...}
End Select

Me.subfrmEvaluations.Requery

Me.subfrmEvaluations!txtAttending = rstSSN!LastName
I get a 2467 error "...object closed or doesn't exist" when the last
statement is executed. The Case statement sets the SourceObject of
subfrmEvaluations. txtAttending does exist on the subform. But even
if I comment that line out, the subfrm does not display.
Me.subfrmEvaluations.Name displays the correct SourceObject name.

Any advice or help is appreciated.

[jimfortune]

ma**********@hotmail.com wrote:

Using A2K. Have the following code in a form just before a subform is
requeried:

Select Case Me.cboEvaluations
Case "Ambulatory Medicine"
Me.subfrmEvaluations.SourceObject =
"subfrmEvals_AmbulatoryMedicine"
{...snipped...}
End Select

Me.subfrmEvaluations.Requery

Me.subfrmEvaluations!txtAttending = rstSSN!LastName
I get a 2467 error "...object closed or doesn't exist" when the last
statement is executed. The Case statement sets the SourceObject of
subfrmEvaluations. txtAttending does exist on the subform. But even
if I comment that line out, the subfrm does not display.
Me.subfrmEvaluations.Name displays the correct SourceObject name.

Any advice or help is appreciated.

Try (air code):

Me.subfrmEvaluations.Form!txtAttending = rstSSN!LastName

James A. Fortune

[manning_news]

Thanks for your reply but I tried that before posting and got the same
error.

ji********@compumarc.com wrote:

ma**********@hotmail.com wrote:

Using A2K. Have the following code in a form just before a subform is
requeried:

Select Case Me.cboEvaluations
Case "Ambulatory Medicine"
Me.subfrmEvaluations.SourceObject =
"subfrmEvals_AmbulatoryMedicine"
{...snipped...}
End Select

Me.subfrmEvaluations.Requery

Me.subfrmEvaluations!txtAttending = rstSSN!LastName
I get a 2467 error "...object closed or doesn't exist" when the last
statement is executed. The Case statement sets the SourceObject of
subfrmEvaluations. txtAttending does exist on the subform. But even
if I comment that line out, the subfrm does not display.
Me.subfrmEvaluations.Name displays the correct SourceObject name.

Any advice or help is appreciated.

Try (air code):

Me.subfrmEvaluations.Form!txtAttending = rstSSN!LastName

James A. Fortune

[jimfortune]

[e-mail] wrote:

Thanks for your reply but I tried that before posting and got the same
error.

Leave it that way. The next step would be to see if you closed the
recordset earlier in the code.

James A. Fortune

[manning_news]

Recordset is open.
ji********@compumarc.com wrote:

[e-mail] wrote:

Thanks for your reply but I tried that before posting and got the same
error.

Leave it that way. The next step would be to see if you closed the
recordset earlier in the code.

James A. Fortune

[jimfortune]

ma**********@hotmail.com wrote:

Recordset is open.

What happens when you comment out the Me.subfrmEvaluations.Requery and
msgbox both Me.subfrmEvaluations.Form!txtAttending and rstSSN!LastName?

James A. Fortune

[manning_news]

rstSSN!LastName displays a name, as it should. But ...txtAttending
gives me the error message again. So somehow the subform is getting
closed or unavailable for some reason.

Hey thanks for your help on this.
ji********@compumarc.com wrote:

ma**********@hotmail.com wrote:

Recordset is open.

What happens when you comment out the Me.subfrmEvaluations.Requery and
msgbox both Me.subfrmEvaluations.Form!txtAttending and rstSSN!LastName?

James A. Fortune

[jimfortune]

ma**********@hotmail.com wrote:

rstSSN!LastName displays a name, as it should. But ...txtAttending
gives me the error message again. So somehow the subform is getting
closed or unavailable for some reason.

Hey thanks for your help on this.

It was kind of you to thank me.

If Me.subfrmEvaluations.Form!txtAttending came up with 'Object closed
or doesn't exist' and the requery works then make sure txtAttending is
the exact spelling of the textbox on the subform.

James A. Fortune

[manning_news]

I fixed the problem by setting the LinkChildFields and LinkMasterFields
in code. Apparently you can't do it thru the subform when setting the
SourceObject using code.

But it works now

Thanks again.
ji********@compumarc.com wrote:

ma**********@hotmail.com wrote:

rstSSN!LastName displays a name, as it should. But ...txtAttending
gives me the error message again. So somehow the subform is getting
closed or unavailable for some reason.

Hey thanks for your help on this.

It was kind of you to thank me.

If Me.subfrmEvaluations.Form!txtAttending came up with 'Object closed
or doesn't exist' and the requery works then make sure txtAttending is
the exact spelling of the textbox on the subform.

James A. Fortune

[jimfortune]

ma**********@hotmail.com wrote:

I fixed the problem by setting the LinkChildFields and LinkMasterFields
in code. Apparently you can't do it thru the subform when setting the
SourceObject using code.

But it works now

Thanks again.

I'm glad you found a solution. I would have never guessed the
LinkChildFields and LinkMasterFields since I have never used them. The
environment I'm in makes for regular compacting so I can get away with
the possible extra mdb bloat caused by changing the RecordSource of the
subform dynamically.

James A. Fortune