Hi Everybody!!,
first of all, thanks for all your support and help.
IŽll try to explain my situation:
I have a table T1 with 2 fields "NAME" and "TEAM"
NAME TEAM
JOHN ----- YANKEES
MARK ----- RED SOXS
PAUL ----- GIANTS
JOHN ----- GIANTS
STEVE ----- RED SOXS
MARK ----- YANKEES
I create a query using parameters, named C1
in his criteria "=[NAME]"
that's make it will appear a pop-up box, where I can introduce a name to filter this query. For example, "JOHN", it would return JOHN -- YANKEES and JOHN GIANTS.
If I want to replace this pop-up box, with a drop-down list box, I need to create a FORM, called F1, with a simple combobox, and create a button with the event code DoCmd.OpenQuery "C1" .
in the query's design properties, in his criteria I wrote forms!F1!C1 and it works!!
But, my question is about to use this system with 2 drop-down list.
I mean, make a query, filtering with "JOHN" and "YANKEES" ... but using a drop-down list, not writing in the SQL-sentence the criteria.
I want just to do the filtering using NAME and TEAM, and sadly, it doesn't work !!
Anybody knows how to do that?
thanks so much for your attention and your support.
PS: I want apologize for my english if I do so much grammar mistakes. greetings from Barcelona!![]()