Any MS Access gurus in here?

[Steve S]

Can’t figure out how to assign a variable to a text box on a form. Want to use the variable in a query.
I have the query. Just can’t figure out the form. It’s been 20 plus years since I used Access.

 

[BirchyBoy]

In the past I’ve used VBA code, called by a button, to call the query. You’d reference the text box something like Me.TextBox1.Value and add that to the query string. I can give a better example tomorrow.

 

[BirchyBoy]

Here’s a good example:

https://www.oreilly.com/library/view/access-cookbook/0596000847/ch01s02.html

 

[Halfhitch]

You guys aren't talking a different language, you're from outer space!

 

[Skybolt]

Can’t figure out how to assign a variable to a text box on a form. Want to use the variable in a query.
I have the query. Just can’t figure out the form. It’s been 20 plus years since I used Access.

It sounds like VBA? Creating a new form based app?

Steve, PM me - I use that stuff every day.