How to pass a variable to a report

Not enough commas..
DoCmd.OpenReport "RBillPatientLetter", acViewPreview,,,, BalReason

<< I would like to now have the input box that the user enters text and then that text is added to the report. >>
  If the form stays open that collected the text, then the simplest is to have the report refer to the control on the form:
=Forms![<myFormName>]![<myControlName>]
That's one way to get data.  Another, which you tried is the OpenArgs argument of the OpenReport command.  To use that however, you need to do something in the report to get what was passed and put it somewhere.  There are various ways to do that.
Another method very similar to that is to use a global variable or array in place of using OpenArgs.  Again, within the report, you need code to fetch the value and do something with it.
HTH,
JimD.

Hi peter57r:,

I tried your solution but the BalReason is not coming in to the report from the code variable.

To retrieve the value in the report, you would use the form open event procedure and do something like:

me.txtboxname = me.Openargs

I'm not following, I have code with a variable of text and I am not using a value from a field on a form.  Could you explain how I could pass the variable's data into the report.  Thanks.

All you said in your Q was that you wanted to able to add the text ( that was passed from your form) into your report.

The code using openargs will do that. It adds it to a textbox in your report.

If you want to do more than that you will have to explain.

Hmm  I gues there is some confusion.  Currently I have a report that uses a variable that is not defined so it prompts the user for the value.  In this case it is a balance reason.

The report is opened by pressing a button.  Now I would like to use an input box to gather this information and then pass that into the form for use.

Is that explained better?

Thanks.

Can I provide any more information to help with a resolution to this?  Thank you.

I think I've got it, the textbox control source is [OpenArgs].... let me do some testing.

Thanks.

Got it working great thanks for the clarification!