Setting value of a text box on a report from VBA code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good Morning,

I have created a coversheet and would like to add a date field. I have an
input box to enter the day to be displayed, but I'm having trouble setting
the text box value to the date supplied.

I'm sorry this is so vague, please let me know what information you need to
answer this issue.

Thank you,
Dan
 
I'm not sure where your input box is. Is it on a form? If so,
you can reference it like any other data source:
=forms!MyForm!txtInput
 
I have a input box popup, but I can't get the value from the input box to
carry over to the form.
 
That's why I asked where the input box was. If it is in your report, you
will have to put a global variable in your report, and reference it in the
OnFormat action of whichever section the data will be in. If the input box
is called from a form, you would put the result in a text box on your form,
and reference that .

In any event, you need to have a variable to hold the value, and then
reference that variable in your report.
 
Back
Top