eroor: Object required

[Mark r]

Sub Comm_change
if Conference!Form.tag = "flag" Then
ctl form.backcolor = vbred
end sub


error is: Object required


Conference is a subform always visible in the mainform
The Comm_change button is in the Mainform
I want the background of the visible subform to turn red
upon clicking the Comm_change button

 

[Graeme Richardson]

Hi, assumption is that Conference is the name of the subform control.
Try
Conference.Form.Tag

ie. use a full stop rather than an exclamation mark

Cheers, Graeme.

 

[Mark R]

I tried it, I got error: OBJECT REQUIRED

-----Original Message-----
Hi, assumption is that Conference is the name of the subform control.
Try
Conference.Form.Tag

ie. use a full stop rather than an exclamation mark

Cheers, Graeme.



.