Query!!! loosing my Mind!!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is really making me nuts...

I have a small form with just one combo box named "HFC" in it. I have the
combo box listing choices from the table named "HFCS".

I have a query built in the first row I have Transplant* "which is the name
of my main table" in the field: and transplant in the Table:. the next row I
have "HUB" in the field: "which is one of the fields in the table Transplant"
and Transplant in the Table: the show box is unchecked. In the criteria I
have [Forms]![Transplantform]![HFC]

I created a macro to open query. It's name query1
Back on the form I have a control box with the macro assigned to it.
When I choose one of the choices and click the control button. the query
shows no records? I can not figure out what I'm doing wrong. Please Plase
Please HELP...

Lime
 
Back
Top