' Selects the edit textfield touched
Sub edtEdit_FocusChanged (HasFocus As Boolean)
If HasFocus Then
EditTxtFocus = Sender
spEquipment.Visible=False
If DBName = "RAWTERMS" Then
If EditTxtFocus.Tag = 0 Or EditTxtFocus.Tag = 4 Then ' tags assigned numerically as edtEdit textfields created on pane
spEquipment.Left = edtEdit(EditTxtFocus.Tag).Left ' places spinner near edtEdit textfield
spEquipment.Top = edtEdit(EditTxtFocus.Tag).Top
spEquipment.Visible = True
End If
Else
EditTxtFocus.Enabled=True
EditTxtFocus=Null
End If
End Sub