Textbox control giving #error in a report (1 Viewer)

[Jimal]

I have two reports for my project
im trying to place a username in the report
surprisingly the second report accepets the username and displays properly in the report, whereas the first one is giving #error.
pretty confused. appreiciate your help

whereas the second form its working properly

Appreciate your help in advance....im not a pro so please forgive my sillyness

 

[arnelgp]

check the Recordsource of each report.
i believe the Working report has a Query for its Recordsource.

 

[Jimal]

Hi @arnelgp
Yes both the reports have a record source based on query.
can u mind explaining how does that impact here

 

[Gasman]

I have no idea as to why you would put an input parameter for a report. I could type any old thing as a User Name?

I would delete the one not working and copy and paste from the one working, if that is how you want to do it.
It would be best to identify the user yourself and put their ID/Name there via code?

Even try changing User to user ? Clutching at straws here.

 

[Jimal]

Hi @Gasman

Idea of the input parameter is as simple as to identify who is generating the report..
I already have tried the idea of copying from the working to the not working...awfully error keeps coming

I could not understand "" It would be best to identify the user yourself and put their ID/Name there via code? "--would you mind to eloborate
thanks in advance

 

[arnelgp]

make Text92 Unbound by removing the "=[enter user name]".
add code to the Report's Load Event:

Private Sub Report_Load()
Me!Text92 = InputBox("Please provide your UserName:", "Username") & vbNullString
End Sub

 

[Gasman]

Hi @Gasman

Idea of the input parameter is as simple as to identify who is generating the report..
I already have tried the idea of copying from the working to the not working...awfully error keeps coming

I could not understand "" It would be best to identify the user yourself and put their ID/Name there via code? "--would you mind to eloborate
thanks in advance

I run the report, it asks for user name, I enter Jimal ???

User should really login to the DB with company userid, etc, then you store that and when you print report or whatever, you use that ID, not one I decide to key in at anytime.?