Searching Access DB for a record

[foldor]

Ok I have an Access Database set up with a BindingSource and I have tried finding a way to search the database for a certain record and then returning true or false depending on whether or not it exists. I tried using the .contains method, but it seems to be for list boxes.

does anyone have any ideas?

Thanks in advance,
Foldor

 

[cjard]

SELECT COUNT(*) FROM table WHERE column = value

returns 0 if value not exists, or a number higher than 0 if it does exist

for more info on creating a parameterized query, read the dw2 link in my signature, section "Creating a form to search data"