On my main form, I currently have 3 subforms.
Subform 1: Active
Subform 2: DeActive
Subform 3: Other
Each subform points to the same data source, but the only thing different in each one is in the criteria row, I have either "Active" or "DeActive" or etc...
This way, each subform will only show a records within a specific status. Well, I'm a bit annoyed having 3 subforms on this form. I would imagine, I can avoid all this with my idea.
Is there any way, to put some code into the criteria row - that basically points it to a text box on my form that contains the value.
For example... My plan is to have 1 subform. Above that, I want a combo box that contains the 3 values (Active being the default value...)
Then when the subform is generated, in the status column it looks for the value of say, "cboStatus" and puts that value into the criteria row.
Does this make sense?
P.S. I know how to make the subform refresh, I just need it to know where to find the value for the criteria row...
Thank you in advance.