Subform Not Recognized as Open-Acc2k

[TGHockett]

Following the suggestion in MS article Q209537,I created an unbound form to hold a combobox and a two page/tab control form/subform. The good news is that the combobox works very well to move to a desired record, but I am getting the following error when a repaintobject action is run from an afterevent macro for another control:

"The object "subform name" isn't open"

I have created a test macro with mssgboxes that shows the two subforms are in fact opened, e.g., Tab 2 then Tab 1 and then the unbound parent form, as would be expected -- so any suggestions would be appreciated.

BTW, the form/subform works just fine when opened outside the parent form mentioned above.

TGH

 

[Rich]

I'm sure a similar question was answered a while back you might find the answer there, I don't have 2k but I prefer to use Me.Refresh as opposed to repaint.
I seem to remember a similar problem myself when using Macros before switching to VBA I think you have to add open form to the macro before your other actions even though the form is open.
HTH

 

[TGHockett]

Hi Rich ... thanks for jumping in, but I did try the workaround you suggested, but that opens the form on top of the parent, so that does little good.

As mentioned before the form/subform I tried added worked perfectly before adding it to the unbound parent form... all of this would be moot of course if the combox box wizard worked ok

TGH

 

[TGHockett]

Still interested to see if anyone else has any other ideas ... TGH