searching for a matching record in a recordset
if given a value from a text field, how can one tell the database (ado) to
along one field until it finds it and then return another field elsewhere
the same recordset? throughly stumpted...
rsADO.open "Select field1,field2, from [table] where field1 = '" & string &
if rsado.eof and rsado.bof then
msgbox "No record!"
answer = rsado![field2]