Looking for some help solving this issue.
I have a combo box (cboContract) that has a query (Q_Contracts) for a row source. This combo box is for Contract Numbers.
cboContract is in a subform (F_Contract), which is within a the main form, that is based on projects (F_Project).
(So, parent form is F_Project and child is F_Contract.)
In F_Contract, I have cboContract and a check box (ckActive) for Active or Not Active, nothing else.
As projects and their respective contracts are closed out, I did not want to see them in the drop down for cboContract when I create a new project.
My first attempt was to place False in the criteria for the Active field in Q_Contracts. That works great for when I create a new project. When I add a contract number, I then choose from the drop down which gives me all the active contract numbers but, when I look back at closed projects (ie. other records) I no longer can see the contract numbers that have been filtered out by the query.
So my question is, how can I filter out the non-active contract numbers for new projects, but still see the non-active contract numbers in the older projects?
I have a combo box (cboContract) that has a query (Q_Contracts) for a row source. This combo box is for Contract Numbers.
cboContract is in a subform (F_Contract), which is within a the main form, that is based on projects (F_Project).
(So, parent form is F_Project and child is F_Contract.)
In F_Contract, I have cboContract and a check box (ckActive) for Active or Not Active, nothing else.
As projects and their respective contracts are closed out, I did not want to see them in the drop down for cboContract when I create a new project.
My first attempt was to place False in the criteria for the Active field in Q_Contracts. That works great for when I create a new project. When I add a contract number, I then choose from the drop down which gives me all the active contract numbers but, when I look back at closed projects (ie. other records) I no longer can see the contract numbers that have been filtered out by the query.
So my question is, how can I filter out the non-active contract numbers for new projects, but still see the non-active contract numbers in the older projects?