Parameters

[romh]

I used to be able to do this but I can;t remember. I would like to set a form's text boxes to the parameters inputed when it is opened. I have a form that filters the records according to the opening and closing dates entered by the user (parameters). I forgot what to put in the control source for the text boxes in the form.

ThankYou

Romh

 

[spikebears]

go to Expression Builder in the Properties of your text box and input (assume name of your form is Myform and name of the user input field is Myfield)

=[Forms]![Myform]![Myfield]

 

[romh]

Thanks, but I tried that and It didn;t work. Any other suggestions?

 

[spikebears]

it produces error or just displays nothing?

if the input box is in a subform, the syntax will be:
= [Forms]![myform]![mysubform]![myfield]

or you can do the other way round, add an AfterUpdate event onto the user input text box to post the input value to your display text box.

Private Sub MyInput_AfterUpdate()
[Forms]![myform]!Mydisplaybox.value = MyInput.value
End Sub

good luck!