We are Access Experts. Call Us Today! 773-809-5456

Code Snippets → Find Next/Previous Specified Day

This code was generously donated by Bob Askew (raskew) from Access World Forums and modified by Bob Larson to be able to look either forward or back.

NOTE: If you use this in a QUERY or Control Source, you have to specify the day NUMBER instead of vbWednesday, vbSunday, etc. because queries and control sources do not know about the VBA constants.