#Name? problem

[PeterWann]

I have been working on a form for several hours. It all worked great. We shut down the database and came back an hour or so later and opened the form up and now all of the text boxes that have expressions in them are giving me a #Name? in them. The interesting thing is if I open the form up in design view and open the control source for the form (the underlying query) and run this query, close it and save changes the form works great! Any ideas?

[June7]

Run Compact and Repair.

Rebuild the form.

Want to provide project for analysis? Follow instructions at bottom of my post.