Changing ComboBox Data

I am working on an application as I try to learn/work with Visual
basic.
I am writing the application in Visual Studio 2005 and am connecting
the Application to an Access Database.
I used the Visual Studio wizard to create the data connection,
datasets etc.

I currently have a compbo box that is bound to "Product Description"
from the tblProducts in my database.
All appropriate textboxes on my main form are populated correctly
whenever the combo box loads or the option in the combo box is
changed.

Now I have 2 menu items, stemming from a "Select" option.
I have Select > by Product ID and Select > by Product Description.

I would like to choose either product ID , or Product Description and
have this choice change the information bound to my combo box. So
instead of displaying product description, it would now display
Product Id, and vice versa (depending on the Select > choice).

I did not manually code the origional databind for the combo box,
however should I have to so that I can create these options I will.
Any advice is greatly appreciated.
Thank you.

.

Relevant Pages

  • Re: No results from query in some contexts
    ... > Either you are connecting to a different db or the ASP app is not formatting ... If I execute this sproc from SQL Server Management studio connected to the ... If I open up the table in visual studio 2005 I see the records. ...
    (microsoft.public.sqlserver.security)
  • VS2005 Remote Debug connection problem
    ... I got error message when trying connecting to remote debugging machine using ... Microsoft Visual Studio Remote Debugging Monitor named 'machine_name'. ...
    (microsoft.public.vsnet.debugging)
  • Re: No results from query in some contexts
    ... maybe even read permission on that table as well. ... ensure you are connecting and executing that proc as you expect. ... > If I execute this sproc from SQL Server Management studio connected to the ... > If I open up the table in visual studio 2005 I see the records. ...
    (microsoft.public.sqlserver.security)
  • Re: How to add a filter?
    ... I tried to compile including the library and now it shows ... I think that I have understood the fact of connecting both filters but ...
    (microsoft.public.win32.programmer.directx.video)