FindFirst for multiple criteria

[AshikHusein]

I would like to know if there is a way to search for a record in a recordset which finds a record on multiple criteria. Foe example I have the following code.

rec.FindFirst "[acct_num] = """ & acct_num_str & """"

I also want it to search on

"[IPO_name] = """ & IPO_name_str & """"

so that the corect record for the matching [acct_num] and [IPO_name] can be found. Effectively, the record which matches the correct IPO_name and acct_num is required. Thank you.

 

[Jon K]

rec.FindFirst "[acct_num] = """ & acct_num_str & """ AND [IPO_name] = """ & IPO_name_str & """"