user paramaters

[GregB]

When A user opens a form it asks them to input begining and end dates as
search critera. This is the paramater. How would I display what the user put
in for the paramater on the form page.

For example...

Records for Date1(user paramter begining date) Through Date2(user paramater
ending date)

Thanks a lot!

 

[Jeff Boyce]

"... it asks them to ..."?

Does this mean there's code that prompts the user for values?

Another approach would be to put two fields in the header of the form, have
the user input begin/end dates there, and have the form display the records
selected for that range.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[GregB]

yes it prompts the user for the value.
I have already put in to much work to do it your alternative way.
Is there any way for what I asked?
Thanks

 

[John W. Vinson]

yes it prompts the user for the value.
I have already put in to much work to do it your alternative way.
Is there any way for what I asked?
Thanks

It's not a heck of a lot of work to a) put two unbound textboxes txtFrom and
txtTo on your Form and b) replace [enter parameter begining date] with
[Forms]![NameOfYourForm]![txtFrom] and [enter parameter ending date] with
[Forms]![NameOfYourForm]![txtTo]. No other changes would be needed to your
form.

That said - if the parameter is [enter parameter begining date], then simply
put a textbox on the form with control source

=[enter parameter begining date]


John W. Vinson [MVP]

 

[Jeff Boyce]

I suspect you'd have to do more work to 'fix' your version than add controls
in a form.

But if you insist, you could modify the code that runs that is prompting for
the two inputs. You'd need to add two variables to collect the inputs, then
you'd need to set the value of the new control you mentioned to concatenate
those two values with the text you mentioned.

Seems like more work to me!

Regards

Jeff Boyce
Microsoft Office/Access MVP