Set Control Source of text box to a public variable 1

[ajaeger]

On the On Load event of a form, I'm trying to set the control source of a text box to a public variable. The code I've tried is:

Me.txtLoginAs.ControlSource = "=" & pstrUserIDValidate

I get #Name? in that field.

Thanks.



Anna Jaeger
iMIS Database Support

http://www.axcedesolutions.com

 

[MajP]

when you manually put in a control source it looks like
fieldName
not
=fieldName

So not "=

 

[MajP]

If you want to return a value instead then you could build a function

public function getUserID() as string
getUserID = pstrUserIDValidate
end function

then the control source is
=getUserID

 

[ajaeger]

I have set-up the function as you specified:

Public Function getUserID() As String
getUserID = pstrUserIDValidate
End Function

On loading the form, the code is:

Private Sub Form_Load()
MsgBox getUserID
Me.txtLoginAs.ControlSource = getUserID
End Sub

The MsgBox returns the correct UserID, but the text box on the form still reads #Name?

Anna Jaeger
iMIS Database Support

http://www.axcedesolutions.com

 

[MajP]

Sorry for the confusion. My assumption is that you no longer would need set the control source in code. Build the function and then, just go to the controls properties and type in: =getUserID()

If you had to do it in code. Then it would be
me.txtLoginAs.ControlSource = "=getUserID()"
But I can not imagine why you would need to do that

 

[ajaeger]

Yes, you're right, I wouldn't have to anymore. Thank you.

Anna Jaeger
iMIS Database Support

http://www.axcedesolutions.com

 

[PHV]

Me.txtLoginAs.ControlSource = "=" & pstrUserIDValidate
what about this ?
Me.txtLoginAs.ControlSource = "=""" & pstrUserIDValidate & """"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886