Use input from form not pop-up parameter

[hvnlysrph]

I am trying to get a query to use the input that will be entered into a form using a control box and not pop-up a parameter box when the form is open. This is the code I am using in the query:




SELECT Customer.CUST_FNAME, Customer.CUST_LNAME, Customer.CUST_ADDRESS, Customer.CUST_CITY, Customer.CUST_STATE, Customer.CUST_ZIP, Customer.CUST_HOMEPHONE, Customer.CELL_NUMBER
FROM Customer INNER JOIN Loaner_Phone ON Customer.CUST_ID = Loaner_Phone.CUST_ID
WHERE (Loaner_Phone.LOANER_ID)=[Forms]![LoanerSub]![LOANER_ID];


Everytime I open the form the parameter box pops up, also whenever I get into the form and change the data in the drop down control box, the parameter box pops-up again asking for the same info. I would just like to change the code to where it will get the information from that drop down box. Any suggestions?

Thanks in Advance.

[June7]

Is LoanerSub a subform?

Where is this query used?

Do you want to provide project for analysis? Follow instructions at bottom of my post.

[hvnlysrph]

The LoanerSub is a subform which I embedded into the Exchange form under the label Loaner Phone.

[hvnlysrph]

Something I am thinking about that would work (if I could figure it out) is if the query is not pulled up by the Loaner ID. Instead that would just pull the information into the form, and when the info is pulled into the Customer id field, that would create the query. That way, what ever is entered into the customer id is what will appear in the form (for example, if the user wanted to search for a customer via the customer ID and the form would pull up the information for the user to verify before assigning it to the loaner id.......if that makes anysense)

[June7]

Two things I have never seen before:

1. Report used as a ControlSource for a subform/subreport control on a form. And further, the report is used in two sub container controls, one on the main Exchanges form and one in the LoanerSub subform. Not able to set the Master/Child links on the latter. This is why you tried the PARAMETERS and WHERE clauses? I have never used a PARAMETERS clause. Why show the report twice or even at all? All of the customer information can be made viewable on the forms by query joins or textbox ControlSource referencing columns of a combobox.

2. Relationships set up between MySys tables. Why are you doing this?