Hello again experts
Im strugling with accessing a subform via VBA which is placed on another form on a tab control.
So the form Im looking for is called: 'TreeLevels subform'. It is placed on form: FormTagValidation which is on tab control's ("TabCtl0") page - 'Validation'.
Tab control is on form 'FirstStage'.
So to e.g. set focus on FormTagValidation or to set focus on page validation I need to use code:
Well I cant make it working for 'TreeLevels subform'
My ultimate goal is to apply query to this subform's RecordSource.
cheers
Im strugling with accessing a subform via VBA which is placed on another form on a tab control.
So the form Im looking for is called: 'TreeLevels subform'. It is placed on form: FormTagValidation which is on tab control's ("TabCtl0") page - 'Validation'.
Tab control is on form 'FirstStage'.
So to e.g. set focus on FormTagValidation or to set focus on page validation I need to use code:
Code:
Forms!FirstStage!FormTagValidation.SetFocus
Forms!FirstStage.TabCtl0.Pages.Item("Validation").SetFocus
Well I cant make it working for 'TreeLevels subform'
My ultimate goal is to apply query to this subform's RecordSource.
cheers