>Thanks for your help Sylvain
>
>Could you please help me further?
>
>I can't figure out how to call the form from a fuction and return the value. Once I know how to do this everything else seems to be working.
>
>Thanks in advance
>
>Nicky
What you have to do here is to declare a public function in your called form and call this function instead of calling form.show.
For example:
FORM1
=====
'instead of Form2.Show vbModal
blnReturn = DisplayForm2
FORM2
=====
Public Function DisplayForm2() as boolean
Me.Show vbModal
DisplayForm2 = True
End Function
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com