Recordset

[Jenny Kurniawan]

Hi-

I have a form that contains a subform.

I found out that subform is always executed first, before the main form.
(Prove: I had MsgBox in Form_Current for both forms. MsgBox
from the subform showed up first before the main form)

Question: Is there anyway I can call the main form _before_ the subform?
There are a few fields in the subform that are dependent on the Main Form.

My problem will be easily solved when the Main form is called first _Before_
the subform.

Please advise,
Jenny

[Jeff North]

Re: Recordset

On Wed, 30 Jul 2003 15:13:50 -0400, in comp.lang.visua l.basic "Jenny
Kurniawan" <jkurniawan@max xiscanada.com> wrote:
[color=blue]
>| Hi-
>|
>| I have a form that contains a subform.
>|
>| I found out that subform is always executed first, before the main form.
>| (Prove: I had MsgBox in Form_Current for both forms. MsgBox
>| from the subform showed up first before the main form)
>|
>| Question: Is there anyway I can call the main form _before_ the subform?
>| There are a few fields in the subform that are dependent on the Main Form.
>|
>| My problem will be easily solved when the Main form is called first _Before_
>| the subform.[/color]

Set your subform to invisible upon opening the entire form.
Once all the criteria is met in the main form then reset the subform
to visible.

It doesn't solve you problem - just hides it :-)
---------------------------------------------------------------
jnorth@yourpant sbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------

[Paul W]

Re: Recordset


"Jenny Kurniawan" <jkurniawan@max xiscanada.com> wrote in message
news:yNUVa.11$q N3.7332@news20. bellglobal.com. ..[color=blue]
> Hi-
>
> I have a form that contains a subform.
>
> I found out that subform is always executed first, before the main form.
> (Prove: I had MsgBox in Form_Current for both forms. MsgBox
> from the subform showed up first before the main form)
>
> Question: Is there anyway I can call the main form _before_ the subform?
> There are a few fields in the subform that are dependent on the Main Form.
>
> My problem will be easily solved when the Main form is called first[/color]
_Before_[color=blue]
> the subform.
>
> Please advise,
> Jenny
>[/color]
Are you accessing any of the controls or properties on the subform. If you
are, that will Load the form. Can you give any other details?

Paul_W