saross
10-25-2004, 05:25 AM
Is this possible in VBA? I have a form, FRMContractInfo, which is based on the query QRYAll. However, on a specific search, I would like to change its value to QRYStaff Contracts... is this possible?
My reason for this is that FRMContractInfo includes a subform FRMStaff which lists staff working on a contract. I want to search on staff working on the contract, but of course these are not listed in the original query as they are displayed in a subform...
My reason for this is that FRMContractInfo includes a subform FRMStaff which lists staff working on a contract. I want to search on staff working on the contract, but of course these are not listed in the original query as they are displayed in a subform...