Me.parent (forms)

[1974maiden]

Hi,

I have some code,

Sub

Dim Parentform as Form, Childform as Form
Set Parentform = Me.Parent
Set Childform = Forms!sfrmChild

If Parentform = Childform
..
..
EndSub

Getting error stating that Forms!sfrmChild is not found and Parentform = Childform (type mismatch). is there something silly i´m doing here.

Thanks, Jimmy

 

[Darrylles]

Hi,

This really depends on where you are calling this code from.

I take it the sfrmChild is a sub form on the parent form?
If so, and you call the code from anything other than the child form, then

Set Childform = Forms!sfrmChild

will not find it.

You need:

set Childform = forms!parentformname!sfrmchild.form

Or there abouts.
Look at 'subform reference' in Access help (.form is important).

Regards,

Darrylle

"Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk