Thanks for the help, Everything worked fine except for one thing.

I setup an option group with 3 selections arriving departing or assigned. My text box control source updates accordingly to the selection I made.    

The problem that comes into play is, say record 1 was selected to arriving and record 2 was departing.

If I return to record 1 from record 2 the option group displays arriving however the control group remains on departing.

Its as if the update is not running when a different record is selected.

Since my code is a little more complicated than my example above I will post it below to make sure i have not made any other mistakes.

Private Sub Status0_AfterUpdate()
If Status0 = 1 Then
   StatusTB1.ControlSource = "InboundFrom"
   StatusTB2.ControlSource = "ArrivalDate"
   StatusTB3.ControlSource = "InboundSponsor"
   StatusTB2.Visible = True
   StatusTB3.Visible = True
ElseIf Status0 = 2 Then
   StatusTB1.ControlSource = "Outboundto"
   StatusTB2.ControlSource = "DepartureDate"
   StatusTB3.ControlSource = "OutboundSponsor"
   StatusTB2.Visible = True
   StatusTB3.Visible = True
Else
   StatusTB1.ControlSource = "Daterpt"
   StatusTB2.Visible = False
   StatusTB3.Visible = False
End If
DoCmd.RunCommand acCmdRefresh
End Sub