I am creating a contact database and I would like the user to create
his own groups of contacts based on criterias, thefore I would like to
let him pick the fields and criteria for a particular group. I don't
wanna a form full of fields that ask the user for arguments. Instead a
subform with a combobox where the user picks the [field], the
[operator], and the [arguement]
So I would have two tables groups and GroupCriteria for instance:
group field operator criteria
____________________________________
Accounts city = brooklyn
Accounts status < active
I then would live to each record to supply the query with these
arguements. Is the wrong way to go about it? How can I create my own
arguement. I see examples on how to pass but how do I create it using
code?