ComboBox to Run Query and enter Parameter

[tristangemus]

I have a query which looks up certain machines in a database then lists the rest of the information in that table that goes along with it. I have created a combo box which I would like to run that query. The items in the drop down would be a list of the machines which would then be typed into the criteria which would then look up that machine. Anyone able to help me with this? Seems simple but I am unable to figure it out. I am a beginner.

[rzw0wr]

Still on my first coffee.
I guess I don't understand what it is you are wanting to do.

The items in the drop down would be a list of the machines which would then be typed into the criteria which would then look up that machine

This line does not make sense to me.

Dale

[tristangemus]

Still on my first coffee.
I guess I don't understand what it is you are wanting to do.



This line does not make sense to me.

Dale

Hi Dale,

In the combobox, I would like it to list each machine.

Once clicked it will run the query and whichever machine is clicked, it would enter that into the parameters for the query.

So the query would have [Machine Name]

And whichever machine was selected from the combobox would be entered into [Machine Name] resulting inthe query looking up that specific machine.

hope that cleared it up.

[rzw0wr]

Ok. You want a combo box with a list of machines, when you select a machine, the data for that machine will populate a form. Correct.

Dale

[tristangemus]

Each machine in the table has many parts. If I were to type the machine into the Query criteria anywhere from 5 to 50 rows would appear.

When the machine is selected, I would like it to enter the machine name into a query that I have created. the query has [Machine Name] in the criteria. Once a machine is entered into the query it will populate the table with the rows which apply to that machine only.

Ok. You want a combo box with a list of machines, when you select a machine, the data for that machine will populate a form. Correct.

Dale

[rzw0wr]

Look at your combo box query. Note the FIRST field there. Mine would be the machine ID.
In the query you want to filter, under that field type, Forms!YourFormName!YourComboBoxName

Change YourFormName to actual form Name and YourComboBoxName to actual combo box name.

Dale

[tristangemus]

Look at your combo box query. Note the FIRST field there. Mine would be the machine ID.
In the query you want to filter, under that field type, Forms!YourFormName!YourComboBoxName

Change YourFormName to actual form Name and YourComboBoxName to actual combo box name.

Dale

Okay, I understand it all except the first line. I'm not exactly sure how to access the combobox query. Am I creating the combo box through the wizard? My apologies, I am very new to Access.

[June7]

rz might be directing you in technique demonstrated by

http://datapigtechnologies.com/flash...tomfilter.html

and

http://datapigtechnologies.com/flash...earchform.html

and

http://datapigtechnologies.com/flash...mtoreport.html

[rzw0wr]

The first entry in your combo box is usually the bound column.
We want this column to filter by.
You can see the combo box query by putting the form in design view, selecting the combo box and looking on the property sheet in the data tab under Row Source.

Dale

Thanks june7.
I was helping my grandson with his train track.

[tristangemus]

Okay still having trouble (sorry folks).

If anyone is willing to get hands on here it would be much appreciated and I have uploaded it to the link below.

http://www.mediafire.com/download/86...nventory.accdb
http://www.mediafire.com/download/p6...ventory.laccdb

[rzw0wr]

Where are the machines in your database?

Dale

[tristangemus]

They are in the parts inventory database and they are under the category database (some are machines some are company names) thats what I would like in the drop down list .

[rzw0wr]

You need to create more tables for this to work.
machines.
parts
vendor
PO Number
Account
Category.

All this data in 1 table will be very hard to manipulate.

Take a look at this site.
http://symplebyte.com/microsoft_offi...ta_access.html

Dale

[tristangemus]

Okay thank you, I will take a look at that.