J
JoMcGuire
Hey there. I've read 10 different threads regarding this error and I
haven't seen a resolution yet. Many of the posts are very old, so I'm
going to try again to see if anyone knows how to fix this.
I would like to say that I am supporting a db that I inherited. I
hope I can accurately describe this.
I have a two forms, MIRs and LIRS. There is a subform on the LIR form
that is only a button that calls to open the rare associated MIR form.
( This is because there needed to be a 3rd qry pulling some info from
the MIR qry and some from the LIR qry to make the association.. sort of
a work around to mis matched data types and the fact that the MIR and
LIR numbers are created in their perspective qrys combining the year
and a consecutive number series )
Its working fine, the subform button only shows up on the records that
have an associated MIR, when you click on the button, the MIR form
opens, and you can Exit the MIR form so that You can see the LIR form
again.
However, if you try to navigate to "next" or "previous" record on the
LIR form (Parent), the message comes up "Object invalid or no longer
set" and the LIR number field has "Error# " instead of the next record
number.
Its like I need to requery or reload the original LIR form, but I'm not
sure how to do that since the action that kills it is seems to be
closing the associated MIR form. If I just minimize the MIR form, I
can continue to navigate through LIRs with no problem.
Any suggestions ?
haven't seen a resolution yet. Many of the posts are very old, so I'm
going to try again to see if anyone knows how to fix this.
I would like to say that I am supporting a db that I inherited. I
hope I can accurately describe this.
I have a two forms, MIRs and LIRS. There is a subform on the LIR form
that is only a button that calls to open the rare associated MIR form.
( This is because there needed to be a 3rd qry pulling some info from
the MIR qry and some from the LIR qry to make the association.. sort of
a work around to mis matched data types and the fact that the MIR and
LIR numbers are created in their perspective qrys combining the year
and a consecutive number series )
Its working fine, the subform button only shows up on the records that
have an associated MIR, when you click on the button, the MIR form
opens, and you can Exit the MIR form so that You can see the LIR form
again.
However, if you try to navigate to "next" or "previous" record on the
LIR form (Parent), the message comes up "Object invalid or no longer
set" and the LIR number field has "Error# " instead of the next record
number.
Its like I need to requery or reload the original LIR form, but I'm not
sure how to do that since the action that kills it is seems to be
closing the associated MIR form. If I just minimize the MIR form, I
can continue to navigate through LIRs with no problem.
Any suggestions ?