Scenario: VS2008

The application has one primary form (frmMain) and a few dialogs. The only dialog that matters in this scenario is frmAddToHumidor. frmMain contains a tab control which includes two tabs (that matter in this scenario...) called TabMyCigars and TabHumidor.

TabMyCigars contains a DGV with textboxes that are populated when an entry in the DGV is selected. TabHumidor simply contains the items sent from TabMyCigars with a little further information. This additional information is entered when someone clicks cmdAddToHumidor on TabMyCigars, which brings up the dialog frmAddToHumidor. This form basically takes all of the information from TabMyCigars and gives the user a dialog to add additional information (in this case, "humidor" and "Vendor").

The shorter version in english is this...

When someone chooses a record (by clicking on it in the DGV) in TabMyCigars then clicks cmdAddToHumidor, they get a small dialog box. This dialog box is ask a few questions, two of which are "What humidor?" and "Which vendor?".

What I need is this:

I need to allow the user to select from a list of humidors and/or vendors. I have tried binding a combobox, textbox (autocomplete), and a listbox to the database to no success.

Perhaps someone has a better idea or could tell me what I'm doing wrong. I have no code because I was using databinding through the properties.