selection of a field in subform (1 Viewer)

aattas

Registered User.
Local time
Today, 14:51
Joined
Dec 24, 2014
Messages
74
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.
 

ashleedawg

"Here for a good time"
Local time
Today, 04:51
Joined
Jun 22, 2017
Messages
154
Nonactive as in disabled? or empty?
 

aattas

Registered User.
Local time
Today, 14:51
Joined
Dec 24, 2014
Messages
74
I thanks for your prompt reply. the "nonactive" or "active" is a field in the subform.
 

bob fitz

AWF VIP
Local time
Today, 11:51
Joined
May 23, 2011
Messages
4,717
Why not set criteria in the query used for the report so it only returns "Active" records
 

aattas

Registered User.
Local time
Today, 14:51
Joined
Dec 24, 2014
Messages
74
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.
 

bob fitz

AWF VIP
Local time
Today, 11:51
Joined
May 23, 2011
Messages
4,717
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

Top Bottom