D
dgoss1
"Cant find the form 'frmMain' referred to in a macro expression or VB code."
The code references a field on another form using 'forms!frmMain!fieldname.value' when the new form is opened. This works when the database window is open. But when I set the database to startup with the database window not opened then this causes the error. It's like it can't resolve the forms collection without the database window opened. Is there any way around this? There is also code in a sub stored in a module that uses the forms collection to access values and it works under both conditions.
The code references a field on another form using 'forms!frmMain!fieldname.value' when the new form is opened. This works when the database window is open. But when I set the database to startup with the database window not opened then this causes the error. It's like it can't resolve the forms collection without the database window opened. Is there any way around this? There is also code in a sub stored in a module that uses the forms collection to access values and it works under both conditions.