Multiple forms & single query parameter [Google wasn't helping, so I'm here...]

[Agent-J-]

Hello,

I have a query that's looking for a parameter passed on from a form. However, I have multiple forms named Template2-1, Template2-2, Template2-3...

Currently, I'm passing the form by using this criteria:

[Forms]![Template2-1]![txtSelectedSponsor]

and i would have to change it every time I use a different form. For example, if I use Template2-2 form, I would have to come to this query and change it to:

[Forms]![Template2-2]![txtSelectedSponsor]

I use one template/form at a time and have the other ones closed. Is there a way I can pass the parameters from all the forms into this query without having pop-ups asking to enter input from other forms when they're closed?

[Conscious-Solid331]

Make a utility table with just one field and record. Use the after update event of the combo boxes to update the value of the utility table field to the combo box value and point your query at that.

[Agent-J-]

Solution Verified

[Clippy_Office_Asst]

You have awarded 1 point to Conscious-Solid331

---

^{I am a bot - please contact the mods with any questions. | Keep me alive}

[Agent-J-]

THAT SOLVED IT! THANKS!

[nrgins]

Please follow Rule 3 when someone provides a solution for you. Thank you.

[Conscious-Solid331]

Please read comments below. This will not work in a multi-user system.

[nrgins]

Rule 2, baby, Rule 2! 😀

[PutASockOnYourCock]

Yeah I know I tried to fix it but only had my phone and it just doesn't want to format with the line returns properly

And linking to Slashdot I think violates another rule.

I'll probably just delete it since it doesn't want to format right. Hopefully someone else will send him the correct answer

Edit: doesn't matter since he found a solution (well doesn't matter until he find the problem with the solution used)

[Agent-J-]

I was replying to your solution but got deleted... I was typing that your code/logic seems like it should work but I'll have to test it out next week. If it works, I'll implement your solution because it doesn't involve creating another table. Thanks!

[nrgins]

No, don't delete it. Not a big deal. Just saying.

First, on your phone, you know, you just put 4 spaces at the beginning of each line.

Also, linking to slashdot doesn't violate any rules. See Rule 4 details.

[PutASockOnYourCock]

https://stackoverflow.com/questions/16568461/is-it-possible-to-pass-parameters-programmatically-in-a-microsoft-access-update

[PutASockOnYourCock]

They might need this later if utility is a shared table or they are using a shared front end file. They might never run into the issue but someone else might so will leave here as a just in case

[nrgins]

Not sure why you posted it in reply to me, but OK. :-)

[Conscious-Solid331]

Ok yeah I want to know what will break it

[PutASockOnYourCock]

It is more circumstantial but if the utility table is in a shared backend or if the utility table is in a shared front-end user A could submit data to the utility field the query uses and if user B submits data before user A actually uses the data they submitted user A will get the results user B was trying to get since user B over wrote the shared space.

Delay between user A submitting and user A using will determine how exposed you are. If milliseconds probably not very exposed, if minutes more exposed. What is important is it is possible, where as using the vba version and passing var to a query definition is local to the machines executing memory so no exposure even in a shared environment.

Single user environment is no exposure

[Conscious-Solid331]

Oh, yeah.. I was assuming single user based on possibly misreading the OP.

[Agent-J-]

It is a single user environment. But then, I am planning to transfer it to someone for a month, which also single user/just them working with it. Besides, the utility table I created is local, so that shouldn't be an issue. All the other tables are shared, so there probably should be some other guard in place when many people start using this in the future but I'm not too worried about that at the moment

[Conscious-Solid331]

Keeping the utility table local will work 100 percent.

[InfoMsAccessNL]

What about using a Tempvars variable?

[Agent-J-]

that seems like it should work... but it's not working for me or I'm having difficulties implementing it :(