Link to home
Start Free TrialLog in
Avatar of Victor Kimura
Victor KimuraFlag for Canada

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
ASKER CERTIFIED SOLUTION
Avatar of mbizup
mbizup
Flag of Kazakhstan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial