eroor: Object required

  • Thread starter Thread starter Mark r
  • Start date Start date
M

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
 
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.
 
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.



.
Click to expand...
 
Back
Top