Refresh a textbox contents

[CoffeeGuru]

I have a Tab Control on a Form
On this Tab Control is a Text Box [Text476] that is linked to a 1 row Table [Period] in my database.
I also have on the Form but outside of the Tab Control a drop down box that allows the user to select a customer.

On selecting the customer an After Update procedure is run that updates [Period] with the correct values - this part works.

What does not appear to happen is my Text Box [Text476] does not relect the new values from [Period]

As part of the After Update procedure I have tried
Form.Requery
Form.Refresh
Form.Repaint

but none of them do anything to [Text476]

Can anyone advise me on what to do.

Thanks

Martin

 

[jdraw]

Please show all the code for the AfterUpdate event.

 

[KenHigg]

Something tells me you need to requery the textbox, not the form to refresh the it

 

[CoffeeGuru]

Please show all the code for the AfterUpdate event.

Private Sub cboChain_AfterUpdate()
Country1 = Me.cboChain.Column(1)
Chain1 = Me.cboChain.Column(0)
DoCmd.OpenQuery "0_Current_user_3", , acEdit
DoCmd.OpenQuery "qryDefaultPeriod001"
DoCmd.OpenQuery "qryDefaultPeriod002"
DoCmd.OpenQuery "qryUpdateYearWeek_0"
Form.Requery
End Sub