Can you provide a simple copy of the database in Access 2007 format?
I am not very good with SQL, but have a lot of experience with Access Queries.
Perhaps you should not have a Null value ie if you do not actually select something in the combo the field defaults to something like N/A or even not identified