Hello,
I'm new on this, so sorry if I get the wrong thread or something like that.
I have a problem with the refresh of subforms in VBA (W2k SP3 and Access 2k). We have 5 forms (well, infact we have 35 forms and 120 modules...) which works properly "alone": the program does what we want, the label's caption refresh ok, and progress bars works properly.
The problem: we have a new form with 5 buttons and a subform. We want to load a form (from the 5 above) into the subform clicking the right button. The form loads ok, the program does what we want but (and, finally, here's the problem) the subform doesn't refresh captions and progress bars.
And curiously (almost for us) this works ok if we click the button for second time.
Well, we put lines like [form_name].Refresh, [form_name].Repaint, DoEvents (with the names of the father-form -I think this is called MDI-, names of son-forms,...) just follows the lines which manage the captions and progress bars (label_name.Caption= "NEW DATA", for example, follows with [form_name].repaint) but this doesn't works at all.
Could anybody help me? Is this the right way to get help?
Thanks for your answers.
I'm new on this, so sorry if I get the wrong thread or something like that.
I have a problem with the refresh of subforms in VBA (W2k SP3 and Access 2k). We have 5 forms (well, infact we have 35 forms and 120 modules...) which works properly "alone": the program does what we want, the label's caption refresh ok, and progress bars works properly.
The problem: we have a new form with 5 buttons and a subform. We want to load a form (from the 5 above) into the subform clicking the right button. The form loads ok, the program does what we want but (and, finally, here's the problem) the subform doesn't refresh captions and progress bars.
And curiously (almost for us) this works ok if we click the button for second time.
Well, we put lines like [form_name].Refresh, [form_name].Repaint, DoEvents (with the names of the father-form -I think this is called MDI-, names of son-forms,...) just follows the lines which manage the captions and progress bars (label_name.Caption= "NEW DATA", for example, follows with [form_name].repaint) but this doesn't works at all.
Could anybody help me? Is this the right way to get help?
Thanks for your answers.