You can go through the Forms collection:
Forms.OtherFormName.ControlName
...using your form and control names of course. Only forms that are open are
in the Forms collection.
>Hi All
>
[quoted text clipped - 21 lines]
>Thanks
>Chrisso

Signature
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.
All of the methods shown below will allow you to reference a control on
another form. The advantage of the first one is that it will provide you
with intellisense, so you can see the name of the controls as well as that
controls properties while you are typing, whereas in the other two methods,
you have to know the controls name and the applicable properties.
Form_frm_Employees.txt_FieldName.backcolor = 255
Forms("frm_Employees").Controls("txt_FieldName").BackColor = 255
Forms.frm_Employees.txt_FieldName.BackColor = 255
HTH
Dale

Signature
Don''t forget to rate the post if it was helpful!
Email address is not valid.
Please reply to newsgroup only.
> Hi All
>
[quoted text clipped - 21 lines]
> Thanks
> Chrisso
Chrisso - 27 Nov 2007 19:26 GMT
> All of the methods shown below will allow you to reference a control on
> another form. The advantage of the first one is that it will provide you
[quoted text clipped - 40 lines]
> > Thanks
> > Chrisso
Thanks RG and Dale. Cheers Chrisso