3 dependent combo boxes on a form

[trigirl67]

The first combo box has the words "id" and "name" to choose form, the second combo box pulls a list of either the names or ids and then the 3 box SHOULD get a date based on either the name or id chosen. I do not know how to do the 3rd query because when I pull date, id and name into the query and put criteria for id and name where they each equals the combo box, it does not work. I just get the dates for the ids and no dates for the names. What do I need to do?