Automatically run parameter from field details

[stu_C]

Hello all


I will try and explain what I am trying to do.
I currently have a list of companies in a drop down list on a order form, what I want to try and do is choose the company for example "Screwfix" from the drop down list, then click a command button to show all previous orders for screwfix in a query.

I currently have a parameter query to do this using parameters but would be very helpful if I could just click a single button and uses the dropdown list selection rather than typing it in again.

I think its fairly simple to do but been racking my brain and cant solve it

Drop Down List Name: DDLCompanyList
Command Button Name: BTNPreviousOrders
Query Name: QryPreviousOrders
Form Name: FrmOrderingForm

anyone who can help would be appreciated

[orange]

Please post a jpg of your tables and relationships so readers can see what you are dealing with.

[JamesDeckert]

It sounds like you want the combobox to do a record lookup for the company data on your form, then a subform showing the previous orders. No need for a button or parameter query.
See if this helps
https://www.youtube.com/watch?v=EdH1aIWaD-0
You'll just need the subform containing the previous orders.