make a form dependent on another form

[nadjib]

Hi everybody,
I am trying to make form2 dependent on form1, knowing that:

1- Form1: contains a Combo Box, associated one field of
table X
2- Form2: contains a number of fields, among them, the first field must specify what the contents of combo box of form1.

What I do: in the form2_load I openform form1.

So My problem is when I load the form2 (who is dependent to the form1) I can't print in the form2.[fileds1] = form1.[The contents of combo box] because I did not choose yet what it is necessary in the combo box.

So I want to know how can I stop the execution of form2_load, to not open form2 until I fill the combo box of form1 ( that I have just opened)


thank you for the assistance

regardely

 

[hymn]

Try something like this below


Dim stLinkCriteria As String

stLinkCriteria = "[Combo Box]=" & Me![Combo Box]
DoCmd.OpenForm "Form Name"




Hope this helps
Hymn