I'm using VB.NET 2003. I'm having problems doing a search on an access database. No matter what I try it always returns false. I can fill the dataset with an entire table but have had no luck filling it with a specific 'recordset' or return set. I've tried using commandselect.commandtext = "SELECT * FROM [scannerlog] WHERE [Department = & "'cbdep.selecteditem & '" I've tried a million different variations thinking maybe I am syntactically incorrect. I've also tried a dataview and the .filterrow or .rowfilter function. It doesn't work either. Any code ideas on HOW to search an access database and fill the dataset respectivley would be greatly apperaited.