Refresh tab control 1

[shaunacol]

I have a tab control with 2 forms called My_data client subform and My_data new client subform

I want the subforms to refresh when I move between the tabs. In previous posts I have seen the following code to work behind the change tab event:

Me.SUBFORMNANME.Requery

So I tried this:
Me.My_data client subform.Requery
but it doesnt like the spaces in my form name. I cant bear to change that as it is referenced all over the place. So I troed this:
Me.[My_data client subform].Requery
but I get invalid refernce to parent property error
I even tried "" but of course that doesnt work either
Any advise appreciated, I hope I dont have to change all the subform names

 

[MajP]

probably.
me.controls("My_data client subform").form.requery

 

[shaunacol]

I hope someone can help as this doesnt work for me. I had the code in the change tab event of the tab control as below

Me.Controls("My_data_allclients").Form.Requery
Me.Controls("Tbl_viewings subform").Form.Requery
Me.Controls("My_data_hot_clients").Form.Requery
Me.Controls("My_data_new_client").Form.Requery
Me.Controls("My_data_Todo").Form.Requery

I was getting the runtime error 449 , object or class does not support this set of events

So i thought that perhaps that was too much so I split these up and put each one behin the OnClick event in each individual tab control but nothing actually happend and they do not refresh. no error messages tho...

Anybody have any ideas...