Very Computer

Here is a code fragment

RecvStock.Recordset.MoveFirst
...
Criteria$ = "ModelNum = '"+ModlNum+"', PONum = '"+POBox.Caption+"'"
RecvStock.Recordset.FindFirst Criteria$

I KNOW that the Criteria is wrong!  I want to know how to query it using
2 or more fields!  Please help me and send e-mail to me at:

Please don't post it here, I don't have the time to wade through all the
posts!

Thanks in advance!

                                        -- Brett Fattori

Criteria$ = "ModelNum = '"+ModlNum+"' AND PONum = '"+POBox.Caption+"'"
                                      ^^^ Use the boolean operators!

Then learn how to use your newsreader's filtering features, or
get one that has them.

Quote:> Thanks in advance!
>                                    -- Brett Fattori

--

WARNING: I cannot be held responsible for the above        They're   coming  to
because  my cats have  apparently  learned to type.        take me away, ha ha!