Certain Fields only show #Name? until I run the Record_Source query.

[ork2002]

I have several fields in a form that will not work at first after opening my database. When I go to "Record Source" under the options and open the query assigned to that form and then just exit without actually changing anything; then all the fields work. Any ideas on how to fix this without having to do this useless step? Thanks!

[ork2002]

Nevermind... I just created an SQL statement under the event "On Load" that ran the query and all is fixed.