H
hufflehuffle
Hi!
Again, I want to filter a form's content depending on a subform field.
Thanks to Allen I know it is possible through code by setting the
master form's record source to an inner join with the corresponding
where clause.
The problem is: I'd like to use Access' Filter function to let the user
specify his own criteria for the filter. But the resulting "Filter"
setting refers to control names ("((Control1.text = "findme"))") so I
cannot simply use this value for my inner join.
Is there a solution for this as well?
Sorry for the [urgent], I'm a little behind schedule
Best regards,
Andreas
Again, I want to filter a form's content depending on a subform field.
Thanks to Allen I know it is possible through code by setting the
master form's record source to an inner join with the corresponding
where clause.
The problem is: I'd like to use Access' Filter function to let the user
specify his own criteria for the filter. But the resulting "Filter"
setting refers to control names ("((Control1.text = "findme"))") so I
cannot simply use this value for my inner join.
Is there a solution for this as well?
Sorry for the [urgent], I'm a little behind schedule
Best regards,
Andreas