VBA Access Searching...

[Besoup]

Hey,
I am looking for a way to search a table of only 2 columns. The first column will have the numbers I am searching and the second column with have descriptions of those numbers. Some of the numbers are yet to recieve descriptions. I would like to be able to perform a search a for a number and return whether or not it has a description. Anyone have a decent idea on how to do this?

Thanks

[RobDog888]

"SELECT Col1, Col2 FROM Table1 WHERE Col2 = '';"

DEpends on your Col2 field data type. If its text then that will work.

[Ecniv]

Depends on how you are outputting it.

if straight from Sql (bound for example)

"SELECT Col1, iif(nz(len(Col2),0)=0,"-- Not Set --",Col2) FROM Table1"

If you are looping through code then put a check for isnull and for zero length. If its either of these then print up "--not set--" in that part, otherwise put in the fields contents

[Besoup]

Well I am getting a number from a form then I want to search column 1 to make sure its there, if its there I need to know if it has a description in column2. I would like to be able to have a msgbox pop up if the number not found or if the number is found and there is no description...