On load of a form i have a txtUser field

Usally this field is Empty when frmOrder is open, if its Empty i want
code to dispaly the UserID from this form[Forms]![frmMainMenu]!
[txtUserID]

If there is is already a number in txtUser, i do not want any numbers
to be changed and just left the same


Can any one point me in the right way for code?

Thanks

Use the form's Load event to do this:

Private Sub Form_Load()
If Len(Me.txtUser.Value & "") = 0 Then Me.txtUser.Value = _
[Forms]![frmMainMenu]![txtUserID]
End Sub

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/


"Simon" <(E-Mail Removed)> wrote in message
news:30794696-7c17-4218-b199-(E-Mail Removed)...
> On load of a form i have a txtUser field
>
> Usally this field is Empty when frmOrder is open, if its Empty i want
> code to dispaly the UserID from this form[Forms]![frmMainMenu]!
> [txtUserID]
>
> If there is is already a number in txtUser, i do not want any numbers
> to be changed and just left the same
>
>
> Can any one point me in the right way for code?
>
> Thanks
>

"Ken Snell [MVP]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Use the form's Load event to do this:
>
> Private Sub Form_Load()
> If Len(Me.txtUser.Value & "") = 0 Then Me.txtUser.Value = _
> [Forms]![frmMainMenu]![txtUserID]
> End Sub
>
> --
>
> Ken Snell
> <MS ACCESS MVP>
> http://www.accessmvp.com/KDSnell/
>
>
> "Simon" <(E-Mail Removed)> wrote in message
> news:30794696-7c17-4218-b199-(E-Mail Removed)...
>> On load of a form i have a txtUser field
>>
>> Usally this field is Empty when frmOrder is open, if its Empty i want
>> code to dispaly the UserID from this form[Forms]![frmMainMenu]!
>> [txtUserID]
>>
>> If there is is already a number in txtUser, i do not want any numbers
>> to be changed and just left the same
>>
>>
>> Can any one point me in the right way for code?
>>
>> Thanks
>>
>
>