Compile Error

Topic

New Reply

I’m getting a Compile Error when I go to print an invoice, and I don’t know why. This is the error I get:

Microsoft Access can’t find the form ‘frmInvoices’ referred to in a macro expression or Visual Basic code. The form you referenced may be closed or may not exist in this database. Microsoft Access may have encountered a compile error in a Visual Basic module for the form.

What am I doing wrong? I have a form called ‘frmInvoices’, so why does it say that it can’t find it?

Jen

Reply | Quote

Replies

Could you supply more details? Are you selecting frmINvoices from the database window, or are you making a selection on a form? If the latter, maybe you could post the code. It sounds like you are trying to reference a control on frmINvoices, but frmINvoices is not open. (Note the difference between a form merely existing and actually being opened. An opened form is the the Forms collection.)

Reply | Quote