using a textbox value as string in Access

Question

I have a table that feeds several reports. For each customer, for example, I have a different report with his own logo, etc, but all these reports gets their data from one table. Each report has a different name which is attached to the customer name in a different column. I have then a form where I select the customer and the respective report name comes up in a textbox. I want to open each individual report with a command button using the following command: DoCmd.OpenReport " REPORT_NAME ", acViewPreview

"REPORT_NAME" has to be replaced with the string value from the textbox for each individual customer from the opening form.

What command should I use to solve this?

I hope this is not too confusing.

Thanks in advance.

Andre · Accepted Answer · 2016-09-02 14:42:22Z

1

Not sure if I'm missing something, but you can simply do

DoCmd.OpenReport Me!theTextboxWithReportName, acViewPreview

or a little more elaborate

Dim strReport As String
strReport = Nz(Me!theTextboxWithReportName, "")
If strReport <> "" Then
    DoCmd.OpenReport strReport, acViewPreview
End If

answered Sep 2, 2016 at 14:42

Andre

27.7k7 gold badges43 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Dan Over a year ago

Dear Andre, Thank you very much for your reply. The first simple line solves my problem very elegant, I wasn't sure how to use the "Me" command. I kept using Me.textbox instead of Me!textbox. Problem solved. Thank you very much.

Collectives™ on Stack Overflow

using a textbox value as string in Access

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related