Victor Kimura
asked on
MS Access continue execution of loop when no return from SQL
Hi,
I have this bit of code:
Set rst3 = dbs.OpenRecordset("SELECT Customer.[ListID], Customer.[Name], Customer.[FullName] " _
& "FROM Customer " _
& "WHERE (((Customer.[Name])='" & student_name & "'));")
sCustomerListID = rst3!ListID
Sometimes though one some records nothing is returned and the program stops execution. How do I continue execution eventhough nothing is returned from the code above?
Thanks,
Victor
I have this bit of code:
Set rst3 = dbs.OpenRecordset("SELECT Customer.[ListID], Customer.[Name], Customer.[FullName] " _
& "FROM Customer " _
& "WHERE (((Customer.[Name])='" & student_name & "'));")
sCustomerListID = rst3!ListID
Sometimes though one some records nothing is returned and the program stops execution. How do I continue execution eventhough nothing is returned from the code above?
Thanks,
Victor
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.