L
lilbit27
Any help is appreciated.
I have a main form\ subform that has 12 forms within it. 12 forms run
off off one query just asking for a different months results. There are
two managers that could have results per month. kate and Ashley. I
created a function that says manager(), a global variable called
gmanager.
In the main form I have to command buttons called Ashley and Julie.
When I click on Ashley, I put gmanager = Ashley (same for Julie,
gmanager=Julie).
Then I tell the subform that visible is set to false to be set true.
The problem I have having is based of what button to click (say I
clicked Ashley) I want each of the 12 forms to run the manager()
function in each query and give me Ashley results. Thus the subform
within the main form would show all 12 months of Ashley results.
I have a main form\ subform that has 12 forms within it. 12 forms run
off off one query just asking for a different months results. There are
two managers that could have results per month. kate and Ashley. I
created a function that says manager(), a global variable called
gmanager.
In the main form I have to command buttons called Ashley and Julie.
When I click on Ashley, I put gmanager = Ashley (same for Julie,
gmanager=Julie).
Then I tell the subform that visible is set to false to be set true.
The problem I have having is based of what button to click (say I
clicked Ashley) I want each of the 12 forms to run the manager()
function in each query and give me Ashley results. Thus the subform
within the main form would show all 12 months of Ashley results.