Trying to get rid of a couple of Parameter Pop-ups...

[eme126]

Hello again,

I created a form from a query that before loading all the controls asks for the Item ID (parameter). This form has two subforms that depend on another two queries; since I want them to show the info for the same item, all three ask for the Item ID, which can be kind of annnoying and does not look too professional. Is there a way I can get rid of two of the pop-ups and still have the three forms display the info of the same item?

And my second question: After the Item ID is entered 3 times, all the info is displayed on the forms. But, if I click the arrow on the bottom of the form (to supposedly go to the next time...but it should not be possible to do this), a "Enter parameter value" window pops-up (one just like the Item id one), and I have no clue where it came from. I cannot find it in the code; and I really want to get rid of it. I could use all the help I can get.

Thanks in advance.

 

[ghudson]

Have the users key the value in a text box. Then reference that text box in all of the queries that need the value. If you can confine the value to a combo box you will ensure that the users can only select a valid value.

The criteria in the queries will look something like this...

[Forms]![YourFormName]![YourTextBoxName]

Ensure you trap for errors or empty record sets.

 

[eme126]

How can I reference the combo box in the queries?

 

[eme126]

Should I change something in the combo box properties?

 

[KeithG]

[Forms]![YourFormName]![YourComboBoxName]

Just like Ghudson said. Put the above in the criteria row.

 

[eme126]

That does exactly the same thing it did before. I was wondering if there is a way that the form would open with everything empty. Then, when people picked a value from the combo box, all the controls got populated with their respective value?

 

[eme126]

Thank you.