parameter prompt multiple times

[wezel99]

Hi, I have a form using a query as a control source so that is prompts the user for a parameter when they open the form.

I also have a listbox that is calling the same query.

The issue I am having is when I open the form it will prompt me twice to enter the same parameter.


Tables:
tblship
tblconsignee
tblbill
tblinvoicedetails

Query
qinv

Form
frminvoice

When the user enters the invoice number it populates the ship, consignee, billing address information. I have the list box to display line items for that invoice.

Currently I just have them enter the invoice number twice.

Is there a way I can take the user input and apply it to my other query? I'm sure there is a more precise way to do this, so I am open for suggestions

 

[pbaldy]

Most of us would have the user enter the criteria on a form and have the query look there.

 

[wezel99]

You mean like a search box? or lookups?

 

[pbaldy]

I mean like a text or combo box on a form where the user would input or select the invoice number, then click a button to open this form.