Another question: I have a form with multiple text boxes on it, and I only want to write one program (and not insert the code into the double click event of every text box).

How do I go about determing which text box has the focus?

or any other suggestions would be great.

John

You can set on the form open event

Private Sub Form_Open(Cancel As Integer)

'The text box you want available
TextBoxName.SetFocus
TextBoxName.Locked = False
TextBoxName.Enabled = True

'The text box you dont want available
TxtNm.Locked = True
TxtNm.Enabled = False

End Sub

You can use the ActiveControl property to refer to the control that has the focus at run time together with one of its properties or methods. The following example assigns the name of the control with the focus to the strControlName variable:

Dim ctlCurrentControl As Control
Dim strControlName As String
Set ctlCurrentControl = Screen.ActiveControl
strControlName = ctlCurrentControl.Name

If no control has the focus when you use the ActiveControl property, or if all of the active form's controls are hidden or disabled, an error occurs.

AvGuy