C casey Registered User. Local time Today, 01:26 Joined Dec 5, 2000 Messages 448 Nov 19, 2002 #1 Hello, Any ideas on how to set a recordset as the domain for a dlookup function? I appreciate any thoughts...
Hello, Any ideas on how to set a recordset as the domain for a dlookup function? I appreciate any thoughts...
pdx_man Just trying to help Local time Yesterday, 17:26 Joined Jan 23, 2001 Messages 1,347 Nov 19, 2002 #2 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.
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.
C casey Registered User. Local time Today, 01:26 Joined Dec 5, 2000 Messages 448 Nov 19, 2002 #3 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.
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 Just trying to help Local time Yesterday, 17:26 Joined Jan 23, 2001 Messages 1,347 Nov 19, 2002 #4 Check out the .NoMatch keyword in Access Help. (As well as the FindFirst)
