If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Object invalid or no longer set"
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 ? |
Thread Tools | |
Display Modes | |
|
|