Scenario:
I have a combo box (cboTab01_F02_UserId) which is visible at all times.
I have a text box (txtTab01_F02_User) adjacent to it.
Prior to selection of the user id (cboTab01_F02_UserId), the text box (txtTab01_F02_User) is not visible based on the following code:
Private Sub Form_Current()
If Me.cboTab01_F02_UserId > 0 Then
Me!txtTab01_F02_User.Visible = True
Else
Me!txtTab01_F02_User.Visible = False
End If
End Sub
When I select a UserId, the following code is used:
Private Sub cboTab01_F02_UserId_AfterUpdate()
Me.txtTab03_txtStartHere.SetFocus
End Sub
This takes me to a specific field (txtTab03_txtStartHere) on another tabbed page which is exactly what I want.
Problem:
When I go back to the original page, Tab01, the user name text box (txtTab01_F02_User) is NOT visible.
The only way it becomes visible is if I close the form and return.
I've tried Me.Refresh and this does not do the job. Using Me.Requery puts me back on the first record and not the current record that I'm working on.
I'd appreciate any help in showing me the error of my ( programming ) ways.



