Nate,

There might be a simpler way suggested by one of our
experts, but I like to deal with dates using values based
on the current default epoch in Access. That said, it's
fairly straight forward in code to find the current day's
date in a bracketed query where weekends and holiday
entries carry with them a flag hidden in an un-displayed
column in your combo. Once found, it then becomes
easy to advance to the next non-weekend, non-holiday
entry in the query.

If this idea doesn't lend itself to your current database
structure, let us know a little bit more about what you
have in your database to work with. If your application
isn't driven by your database, it will usually give difficulty
trying to solve these types of issues.

Bill