setting textbox value in subform from main form

[taikin]

hi, the title says it, i can't seem to set the textbox value in subform from main form as error pops up saying there is no focus on it but when i tried to set focus on the textbox before setting the the text, access says it can't set focus on the object.

Me!subfCoach!cmbStatus.SetFocus
Me!subfCoach!cmbStatus.SelText = "Inactive"

 

[SQL_Hell]

hi, the title says it, i can't seem to set the textbox value in subform from main form as error pops up saying there is no focus on it but when i tried to set focus on the textbox before setting the the text, access says it can't set focus on the object.

Me!subfCoach!cmbStatus.SetFocus
Me!subfCoach!cmbStatus.SelText = "Inactive"

Hi, I cant remember the syntax exactly.

Google it, by typing Access VBA sub form reference

 

[dcx693]

The .SelText method returns to you the text that was selected. It doesn't set the value of the text box.

To do that, something like:
Me!subformName.Form!ControlName= "Inactive"

Read Mile's FAQ: Syntax for Main and Subforms