Programming lang: VB.NET
Database: Access 2007

I have a form which gets data from a database(access 2007) subject to the value in a combobox. Now i hard coded this by coding if the value in the combobox equals xx then display the data from the database in a listbox.

My probelm is my sql statement uses only the refrence number for the data becuase it is looking at data from a lookup field in access.
...