DLOOKUP #Error

[neo651]

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?

Thank you.

[ssanfu]

"cboWeekOf" is NULL when the form opens, so the DLookup function returns an error.
Try setting the default value of the combo box "cboWeekOf" to DATE().

Close, then reopen the database.

There are other ways to populate the controls instead of setting the control source to a DLOOKUP.
One way sould be: in the after update event of the combo box "cboWeekOf", you could have code that pushes the value from the DLookUp function into the respective controls. The DLookup would only be executed when the combo box "cboWeekOf" is changed.

[neo651]

I do have a default value set for cboWeekOf, it's set to an expression that returns the date of the Monday of the current week.

[ssanfu]

I have never heard of that happening before. Would you post the DLOOKUP expression?

[neo651]

=DLookUp("Stats_To_Date_2012","qryData","[Office]=1 AND [Panel]=13")

This is one of them, they're all identical syntax with "Stats_To_Date_2012", "1" and "13" swapped out for different values depending on what's being looked up. It's not a complex expression.

[ssanfu]

Now I'm more confused. How are the DLOOKUP()s connedted to the combo box "cboWeekOf"?
Is "cboWeekOf" a parameter for "qryData"?

Are all of the domains for the DLOOKUPs the same ("qryData")?

You might read this post. See post #10 by Rod.
https://www.accessforums.net/queries...ror-30691.html

[neo651]

There are three different queries used as the domain for the different DLOOKUP expressions. All of those queries use the value of the combo box as a criteria.