Enter Parameter Value Error

[eric.nguyen312]

Hi, I'm trying create a form called 'Create Proforma Invoice'. The
form is a duplicate of 'Create Product Invoice'. The only difference
is 'Create Proforma Invoice' adds 'PF' in front of the invoice #. What
I've done was I copied Invoice_frm and renamed it Proforma_frm and
create a button that points to the Proforma_frm. When I open the
Proforma_frm I get this 'Enter Parameter Value:
Forms!Invoice_frm!cmbInvoiceNumber' box. Can someone tell me what I'm
doing wrong?

Thanks!

 

[strive4peace]

you probably have criteria in your query that gets its values from
Invoice_frm ... this form has to be open! and cmbInvoiceNumber needs to
be filled out

if the form is not open, Access cannot get the value, so you are
prompted for it...

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[eric.nguyen312]

Got it!! Thanks!

you probably have criteria in your query that gets its values from
Invoice_frm ... this form has to be open! and cmbInvoiceNumber needs to
be filled out

if the form is not open, Access cannot get the value, so you are
prompted for it...

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[strive4peace]

you're welcome, Eric happy to help

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*