I have a multiple table query that is initiated from a Select form. I have four combo boxes, two option buttons as of right now. This is to filter down what is included in the results.
My query has fields for what will show up. I have three fields, that are used rarely but do sometimes have data that needs to be shown.
What I am trying to do is if the checkbox on the form is checked (True) then make the column in this query visible. Ive tried a couple criteria in the query filed such as:
IIf([Forms]![frmSelectToExport]![chkboxTrustInfo],True,[tblTrustAnnu]![TrustAmount].[Visible]=True)
Ive tried also referencing the query [qryListExport]![TrustAmount].[Visible]=True)
I've tried column hidden= false. Any variation I could come up with. All it does is return no values at all in the query and the column does not show up. I tried a little vba also but wasn't sure how to refer to the query going to data sheet view.
Is this even a possibility to do or am I way off base?
Thank you
Kathy
My query has fields for what will show up. I have three fields, that are used rarely but do sometimes have data that needs to be shown.
What I am trying to do is if the checkbox on the form is checked (True) then make the column in this query visible. Ive tried a couple criteria in the query filed such as:
IIf([Forms]![frmSelectToExport]![chkboxTrustInfo],True,[tblTrustAnnu]![TrustAmount].[Visible]=True)
Ive tried also referencing the query [qryListExport]![TrustAmount].[Visible]=True)
I've tried column hidden= false. Any variation I could come up with. All it does is return no values at all in the query and the column does not show up. I tried a little vba also but wasn't sure how to refer to the query going to data sheet view.
Is this even a possibility to do or am I way off base?
Thank you
Kathy