Auto-filling textboxes with Value from other form

[jle0003]

I have a Logon form that contains 2 textboxes: "UserID" and "Password"



I have a Work Order form that has an "Opened By" field.

I would like to auto-fill the "Opened By" field with the "UserID" entered on the Logon form.

How can I do this? Detailed explanation greatly appreciated. I've tried several things and can only get the #Name? response.

Thank you!

[Missinglinq]

A number of ways to do this, of course! Is the order of events here

• Sign in to Logon Form
• Open WorkOrder Form
• Enter New Work Order

If so, something like this, using the OpenArgs parameter to pass the UserID:

In the Logon Form

Private Sub OpenWorkOrderForm_Click()

DoCmd.RunCommand acCmdSaveRecord

If Not IsNull(Me.UserID) Then
  DoCmd.OpenForm "WorkOrderForm", , , , , , Me.UserID
 Else
  MsgBox "A User ID Must Be Entered First!"
 End If

End Sub

In the WorkOrderForm

Private Sub Form_Load()

If Not IsNull(Me.OpenArgs) Then
  DoCmd.GoToRecord , , acNewRec
  Me.[Opened By] = Me.OpenArgs
 End If

End Sub

The Square Brackets are only needed around the Opened By Control name if there is a Space in the name.

Linq ;0)>

[jle0003]

The order of events is as follows:

• Sign in to Logon Form
• Auto opens Main Menu Form
• Select "New Work Order" command button to open NewWorkOrderForm
• Enter New Work Order

[Missinglinq]

Then use the same technique to 'move' the UserID to the Main Menu Form and then again to the Work Order Form.

An alternate in 2007/2010, although I've never used it, would be the assigning the UserID to one of the new TempVars. I believe that this is the correct syntax, but if you have problems, simply use the Access Help.

To assign a value to a TempVars

TempVars.Add "UserName", Me.UserID

To use the TempVars, in the Work Order Form, for a New Record

Private Sub Form_Current()
 If Me.NewRecord Then
  Me.[Opened By] = TempVars!UserName
 End If
End Sub

Linq ;0)>

[jle0003]

Got it working! Thank you so much!

[Missinglinq]

Glad we could help!

Linq ;0)>