Pass UserForm variables into Query

[allend5]

I am trying to create a userform that will allow me to change the criteria of a query i.e. search based on surname and DOB. I recorded a macro to give some idea of what I am trying to do:

Please Login or Register  to view this content.

I thought it might be as simple as tweaking the above code with a TextBox.Value approach? Any help will be greatly appreciated.

[Kaper]

Indeed, you can include textboxvalues into a query in a manner similar to:

Please Login or Register  to view this content.

etc.

But if you plan to use the forum please adhere to forum rules (edit your post).

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

[allend5]

Hi Kaper,

Fairly new to this forum business as you have highlighted. I have updated my post thank you for pointing this out. I have tried your code and it works. There are however a couple of questions that I have. DateBox I am assuming that this is another Control option available in userforms, however this appears to be missing from my toolbox? Secondly is it possible to have the results of this code display in a list box?

[Kaper]

No, I just used such names (when I design userform I try to have meaningful names to all controls) so if you not played with your userform, probably these textboxes are just textbox1, textbox2 etc.

Of course you could use a kind of datepicker control (not in a toolbox - but see for instance here: http://www.rondebruin.nl/win/s8/win003.htm )

As for last part - it's a side question, not fitting thread title, so may be better search forum for (probably answered here) and if not found possibly start a new thread.
You could also start reading for instance: http://www.excelforum.com/excel-prog...o-listbox.html or http://www.fontstuff.com/vba/vbatut10.htm

[allend5]

Kaper,

Thank you for your help. As I say this is all fairly new to me so will probably create a new thread.

Regards,