DLookup w/ rs as domain (1 Viewer)

[casey]

Hello,

Any ideas on how to set a recordset as the domain for a dlookup function?

I appreciate any thoughts...

 

[pdx_man]

I wouldn't use the DLookup function ... I would use the .Filter method or .FindFirst with whatever criteria I would have normally used in the DLookup.

 

[casey]

Thanks for the response.

Can I use .Filter and then test for no records in recordset? I need to find whether a record matches a test condition and then update or add a new record depending on the test condition.

 

[pdx_man]

Check out the .NoMatch keyword in Access Help. (As well as the FindFirst)