Form Initialize

[stlrain95]

If I create a form in VB...then there is an option for Initialize. But if I create a form in Access, I don't get the same luxury. I want a message box to pop up before the main window loads. This will insert the data into the main window.

Private Sub UserForm_Initialize()
Dim person As String
txtPerson.Text = InputBox("Enter QC Operator Name:&quot
End Sub


I am currently doing this in Excel...but am having a hard time translating to Access.

Thank you,

 

[jdegeorge]

You can do that in the form's ON LOAD property.

Jim DeGeorge

 

[LittleSmudge]

Is this what you need

Private Sub UserForm_Load()
Dim person As String
txtPerson = InputBox("Enter QC Operator Name:&quot
End Sub




Note: The .Text at the end is an unnecessary taurtology as .Text is the default property of a Text Box Control anyway.







G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[stlrain95]

For some reason, I was getting an error for Focus...but when I take the .txt out...it works great.

Thank you,

 

[LittleSmudge]

To quote the MSAccess's own Help File

Note To set or return a control's Text property, the control must have the focus, or an error occurs.

If you don't specify .Text then it is the .Text property that gets set but the control does not need the focus.


'ope-that-'elps.



G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[stlrain95]

Thank you for the lesson....I will take it forward in my future learnings!!