Assigning a combo box

[chr1stoper1]

Hi guys I have a query which is currently using a prompt box to ask the user to input a machine number. This is run from a button on a form. Press the button and the prompt appears .I would like to now do one of two things either make a form with every machine number on it or use a combo box to select the machine number. My problem is that I don't know how to get the combo box or the control button to link to the individual machine number. Could any of you guys point me in the right direction here please??


Thanks for your help

[Homegrownandy]

click the combo box in design view, follow the wizard. on the first page click use values from a table or query and it will list them there for you.

If you want the selected choice to be used as a reference you click remember value for later use. Then if you want to pull up data relating to your choice, you must reference the combo box by its name.

hope that's helped a bit. ask anything specific you like.

[nick404]

If you have a lot of machines I would suggest whipping up a quick query that just pulls up all the machines #s so you can use that as the combo's row source. If it is only a few numbers than you can enter them yourself or use a query if you desire.

In design view click the combo box, in the properties box go to the 'data' tab, then the third option down says 'row source type'.
If you are using the query it is defaulted as such. If you want to type the values use the drop down and pick "value list".
Then the option above says 'row source'. Click the (...) and type your values.
If you use the query option it will bring up a query builder and you can select your query from that and drag the machine number field down into the query builder column.

Or you can use the wizard like Andy describes above.