I have a custom Microsoft Access program to handle budget spending.
In that program, I have a drop-down box for users to pick the budget year and it is NOT tied to a field in the table. It is a variable on the form. I am just using it in the query that is run when user clicks on "Select Account" drop-down menu (see the query screenshots above).
After I choose any budget year from "Select Budget Year" drop-down and click "Select Account" drop-down, it displays budget account numbers that belong to currently selected budget year in the "Select Budget Year" drop-down.
However If I change the budget year in the "Select Budget Year" drop-down and click "Select Account" drop-down, then it still displays old budget year account information.
In other word, my query does NOT grab newly changed value from "Select Budget Year" drop-down. I think it is because it is a variable on the form, not tied to actual field on the table.
How do I fix that so that every user selects different year, it will be reflected in my query.
Here are control names:
Select Budget Year Drop-Down: VarBudgetYear1
Select Account Drop-Down: Combo111