Quiet day. Not much happening. Gonna play outside for a while next. Nice day for it!

mibus: If you want a pop-up to ask for a parameter for a query just put [You! User! Enter foo:] in the criteria row on the QBE-screen for that column.
To be able to get a value from a control on a form, that form has to be opened (does not have to be visible). So another thing you could do is open the form in dialog mode, have the user enter a value and hide the form, all before you run the query. Then the query can get the value from the now hidden form.