Customizing a Parameter Query

[Hellfire]

Hi All,

I have a form that my users use to enter information on. On this form, certain fields are combo-boxes, so they only select a value from the drop-down.

I have a parameter Query that run on the same field. Is there a way of getting the values from the combo-box when prompted to enter a value?

Or even better yet, is there a way of changing the appearence of the standard pop-up asking to enter the parameter?

Thanks,
H

 

[Rich]

Change the criteria to reference the form and control
ie Forms!MyForm!MyCombo

 

[Hellfire]

Hi Rich

Ok, I am very new to Access, and I am not sure how do go about actually implementing your suggestion.

I have created a new form and called it frmProducts I have placed a combo-box on the form, the control source of the combo set to my table tblProductlist (This is the table where all the values that I want displayed in my combo-box is stored)

I have created a parameter query, when this is executed, the standard access-box display, asking you to type in the product. How do I go about replacing the standard Access display with my newly created form.

Thanks for your help
H

 

[ColinEssex]

Hi

As Rich doesn't appear to be about at the moment I'll try to help you.

If you have a form which selects a value via a comboBox you don't really need the query to be a "parameter" one - i.e. in the criteria of the query - use Rich's criteria

Forms!MyForm!MyCombo

Don't put anything in square brackets [] as Access will assume it needs user input.

Further idea, ff you put a command button on the form you can then run the query via a macro. So the user will select from the list press the button and there's the result.

Hope this helps
Col

 

[Hayley Baxter]

Hi Andre

Where have you been hiding? I think this sample might be of some help to you.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=33252