A Little Help Please

[kwazie_boy]

I want a query where instead of being asked 'what month would you like' and the user has to type the month manually, I would like a drop down list to appear in the box and the user being able to select from that...how would i do this. Thanks a lot, Will

 

[PeteJM]

The best way would be to create a form with a combo box that contains the months and a button to run the query.

If you the enter Forms!FormName!ComboBoxName into the query in place of the [ ] that you are currently using it should work.

Regards

Pete

 

[kwazie_boy]

i have tried messing with that but am having trouble. any chance of a mini tutorial step by step? cheers, Will

 

[mresann]

To post the list of months is quite simple. You can just set the combobox RowSourceType to "Value List", and then RowSource to "Jan";"Feb";"Mar";"Apr";"May";"Jun";"Jul";"Aug";"Sep";"Oct";'Nov";"Dec"

But to use the combobox to use the values to filter, say, date values, would be a little more difficult than using numbers that can be used in Date format functions. For that, you can still use the Value List, but adjust the RowSource as follows:

1;"Jan";2;"Feb";3;"Mar";....;12;"Dec"

The elipses should be filled in with the numbers and months in between.

On properties, click the Format tab. On column count, enter 2, and in column widths, enter 0;.6

Now open the form with the combo box. You will still see the months in a single column. However, the combo box VALUE will be the month NUMBER, so you can now use the combo box in date calculations and operations.

 

[kwazie_boy]

To post the list of months is quite simple. You can just set the combobox RowSourceType to "Value List", and then RowSource to "Jan";"Feb";"Mar";"Apr";"May";"Jun";"Jul";"Aug";"Sep";"Oct";'Nov";"Dec"

But to use the combobox to use the values to filter, say, date values, would be a little more difficult than using numbers that can be used in Date format functions. For that, you can still use the Value List, but adjust the RowSource as follows:

1;"Jan";2;"Feb";3;"Mar";....;12;"Dec"

The elipses should be filled in with the numbers and months in between.

On properties, click the Format tab. On column count, enter 2, and in column widths, enter 0;.6

Now open the form with the combo box. You will still see the months in a single column. However, the combo box VALUE will be the month NUMBER, so you can now use the combo box in date calculations and operations.

thanks for that but i was after a tutorial to explain how to make my combo box appear in the query popup when asked which month you want to find...

lets say i create a from called querysource and put my combo box in there which contains all the months listed. How would i make that combo box appear when the query is run and the user is asked to select a month to search for.

Thanks, Will

 

[ScottGem]

i have tried messing with that but am having trouble. any chance of a mini tutorial step by step? cheers, Will

What did you do and what didn't work?

The way this works is by being able to reference a control on a form using the syntax:

=Forms!formname!controlname

So you set up an unbound form with an unbound combo where you select a value. Then set the criteria in your query to reference the value selected.