I have a Form called frmMain with a number of controls who's Control Source is a DLOOKUP() expression. The values are looked up from a couple of different queries. Within frmMain there is an unbound combo box (cboWeekOf) where the user can select a date. This selection is used as a criteria for those queries. The DLOOKUP expressions all work perfectly fine until I close and reopen the database, at which point they all display "#Error". I found that if I change the name of cboWeekOf, close frmMain, reopen frmmain, rename cboWeekOf to its original name, then close and reopen frmMain again everything works fine. But I have to do this everytime I open the database file.
Has anyone ever encountered this?