Data verification

I'm using 2003, with an access. My program is a scanner check in / out program. I need a bit of help with the syntax for comparing a string value in a textbox to a row in a column in a table. So that a person cannot check out a scanner that has been checked out or check in a scanner that hasn't been checked out. Also, someone shouldn't be able to check out a scanner that isn't in the master record database. In short, how would I fully qualify the search and then cast to a string for comparison to the LH value????

dim txtasset as string

if txtasset is dsscanners.tblscanners.fldasset_column.tostring then
'do stuff here
end if

This just returns the name of the field.


Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!