Hello everyone.
I am trying to find a way that I can set a value to a variable and reference later.
More specifically, I am developing a database that is linked to SQL tables. One table records problems from three different operations.
Here's what i would like to see:
My Welcome form (first to open when Access is opened) pops up. Within that form there would be three selections (to cover the three operations). For example PM1, PM3, and PM4.
If the user selects PM1 (for example) the next form would have some code that says IF somevar = 'PM1" then only show records where operation field = 'PM1'.
Now, i think you set the variable as:
Public Operation As String
in a module.
My problem is setting the variable to = PM1, PM3 or PM4 depending on the selection in the actual Welcome form so that i can reference it later.
Can anyone show me (1) how I set a value to the variable and (2) how I would reference it later.
Thanks.
john
Your limits are only as far as you set your boundries......
I am trying to find a way that I can set a value to a variable and reference later.
More specifically, I am developing a database that is linked to SQL tables. One table records problems from three different operations.
Here's what i would like to see:
My Welcome form (first to open when Access is opened) pops up. Within that form there would be three selections (to cover the three operations). For example PM1, PM3, and PM4.
If the user selects PM1 (for example) the next form would have some code that says IF somevar = 'PM1" then only show records where operation field = 'PM1'.
Now, i think you set the variable as:
Public Operation As String
in a module.
My problem is setting the variable to = PM1, PM3 or PM4 depending on the selection in the actual Welcome form so that i can reference it later.
Can anyone show me (1) how I set a value to the variable and (2) how I would reference it later.
Thanks.
john
Your limits are only as far as you set your boundries......