I have a single table I'm interested in querying.
The user needs to select some entries, say a date range, another field, and finally make a list of several possible and existing enties in a final field. I want to design a "query/report generator form" that makes this possible.
table name is tblShortForm, a few fields are named: IncidDate, NYPRT, and ProcICD9. So on this form I have combos for date range, for the choice of one NYPRT, and I want a subform to enable the user to choose any number of possible ProcICD9 items before executing a query.
I've got a subform, sfrm ProcICD9, that will enable selecting (existing) items from that field in the table, i.e. via a SELECT DISTINCT query that displays a list of all existing examples of that field, without duplicates.
But I've not been able to put this together; any example out there I could look at?
Tnx,
Tom
The user needs to select some entries, say a date range, another field, and finally make a list of several possible and existing enties in a final field. I want to design a "query/report generator form" that makes this possible.
table name is tblShortForm, a few fields are named: IncidDate, NYPRT, and ProcICD9. So on this form I have combos for date range, for the choice of one NYPRT, and I want a subform to enable the user to choose any number of possible ProcICD9 items before executing a query.
I've got a subform, sfrm ProcICD9, that will enable selecting (existing) items from that field in the table, i.e. via a SELECT DISTINCT query that displays a list of all existing examples of that field, without duplicates.
But I've not been able to put this together; any example out there I could look at?
Tnx,
Tom
