Using a Macro to Enter Text into an Input Box

[oleander]

Hi everyone!



I have a report in access that asks for two criteria to complete the query before running the report. What I want to do is create a form with buttons for all the different combinations of text that could be entered so that when you click on a button, it'll automatically complete the query and generate the report. Is that possible?

Thanks!

[pbaldy]

Sure. I'd use VBA but a macro would also work. A macro would use SetValue or SetProperty. In VBA

Me.TextboxName = "Your text here"

[oleander]

Hmm. I tried using SetProperty to with the values being what I wanted entered in the pop up, but when I clicked the button nothing happened. The input box just popped up like normal and the macro stopped.

If I try the VBA, how do I know what the name of the pop up box is?

[pbaldy]

Sorry, I meant that you would have the macro/code populate a textbox on the form, and you'd point the query to that textbox rather than use bracketed criteria.

[oleander]

Oh, interesting! I think I see what you're saying. I'll give that a shot!

[pbaldy]

Most of us use forms to gather user input. You have a lot more control than using bracketed parameters.

[oleander]

So, I guess the next question is, what exactly do I put in the criteria in the report query? I set up the button so that it puts the text I want into the textbox, and I've gone into the query and used the builder to put in...

[Forms]![FormWithTextBox]![TextBoxName].[Text]

But I'm not sure if the .[Text] at the end is correct? When I use that and save everything, the report isn't coming up with the right data.

[pbaldy]

No, you don't want the text at the end. Try

[Forms]![FormWithTextBox]![TextBoxName]

changing the names of course. See here for more on the text property, if you're bored:

http://www.baldyweb.com/ValueText.htm

[oleander]

Hmm, nope, that doesn't seem to do it either.

The values I want are definitely showing up in those text boxes, and I have the string with the correct names of the form and the text box set in the criteria, but the report just doesn't show any data.

[pbaldy]

Can you attach the db here?

[oleander]

Oh my god I'm an idiot. I was using a criteria to test everything out that usually we have data for but don't currently. Which is why nothing was showing up.

It works fine now. Thank you for your help!

[pbaldy]

We've all done it! Glad you got it working, and welcome to the site by the way!