selection of a field in subform

aattas

Registered User.
Local time
Today, 09:17
Joined
Dec 24, 2014
Messages
75
hi guys,

I have a small problem, (i think).
I am using access 2010 and i have two forms, main and subform (Continuous).
In the subform i have a field that if it is NONACTIVE i dont want the data in the subform be printed in the report. and when it is ACTIVE the whole thing appear in the report.
Any help is highly appreciated.
 
Nonactive as in disabled? or empty?
 
I thanks for your prompt reply. the "nonactive" or "active" is a field in the subform.
 
Why not set criteria in the query used for the report so it only returns "Active" records
 
wow. that really works. thanks.:D:D:D:D:D
But now if i want to see the non-active, i guess i have to create a separate query.
 
wow. that really works. thanks.:D:D:D:D:D
But now if i want to see the non-active, i guess i have to create a separate query.
That would be one way.
I might suggest an unbound form with a combo box which offers the selection of "Active" or "NonActive". Then change the criteria of the query to reference the combo box on the form. You could then put some code in the After Update of the combo box to open the report once a selection has been made
 

Users who are viewing this thread

Back
Top Bottom