asked on

Cannot assign value to text box.

Seems like an easy one...

I have a global variable that I am correctly populating. I want to take that var and put it in a report to print. Below is my code for the report. I get a

Run-time error '-2147352567(80020009)':
You can't assign a value to this object.

My globals are defined as:

Global globalUsername As String

Thanks.

Private Sub Report_Open(Cancel As Integer)
Me.Text32 = globalFirstName
Me.Text34 = globalLastName
Me.Text35 = globalUsername
Me.Text36 = globalPW
End Sub

Open in new window

Shanmuga Sundaram D

why not try in other event. for eg in load event?

gemailj

all you have to do is to use Text property instead of assign a string to the textbox
like this (Me.Text32.Text = globalFirstName)
instead of (Me.Text32 = globalFirstName)

Private Sub Report_Open(Cancel As Integer)
Me.Text32.Text = globalFirstName
Me.Text34.Text = globalLastName
Me.Text35.Text = globalUsername
Me.Text36.Text = globalPW
End Sub

Open in new window

Neil2526

ASKER

Almost there, gemailj.

I used your suggestion and got an error about focus. So I then added:

Me.Text32.SetFocus before assigning values.

I then got the following error:

myDatabase does not allow you to use this method in the current view.

Does that have anything to do with the way I am calling the report?
below...

DoCmd.OpenReport "rptUsername_Password_populated", acViewPreview

Open in new window

gemailj

no it is not related with how you openthis report,
it is about using this code in -- open event
try to use it in -- load event

Neil2526

ASKER

Thanks for the info, i am currently using this and my break point is not getting hit.

Private Sub Report_Load()
Me.Text32.SetFocus
 
Me.Text32.Text = globalFirstName
Me.Text34.Text = globalLastName
Me.Text35.Text = globalUsername
Me.Text36.Text = globalPW
End Sub

Open in new window

ASKER CERTIFIED SOLUTION

Neil2526

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial