Results 1 to 2 of 2

Thread: Compile Error

  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Thanked 0 Times in 0 Posts

    Compile Error

    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?


  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Crystal Beach, FL, Florida, USA
    Thanked 40 Times in 39 Posts

    Re: Compile Error

    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.)
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts