View Full Version : Subform Not Recognized as Open-Acc2k


TGHockett
04-05-2001, 01:22 PM
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
04-06-2001, 04:43 AM
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
04-06-2001, 12:36 PM
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 http://www.access-programmers.co.uk/ubb/smile.gif

TGH

TGHockett
04-09-2001, 07:57 PM
Still interested to see if anyone else has any other ideas ... TGH