Constructing a combo's value list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi all

My form, frmDivStats, has an unbound combo called cbxDiv. The form's record
source is qryDivStats. One of the fields in the query is DivCount.

As a new coder, I can't quite get the following to work. I want the combo's
row source to be a list of two columns where, if DivCount = 4 for example,
the combo's list would be:

1 Division 1
2 Division 2
3 Division 3
4 Division 4

(always in ascending order from 1 to DivCount)
thank you in advance
 
Hi Victoria,

I think you are saying that you want to restrict the list of divisions by
the number you want to see, eg: if divcount is 4, you want 4 returned, if
divcount is 10, you want 10 returned etc.

If this is the case, use the TOP keyword in the query. eg: select TOP 4 *
from qryDivStats

Hope this helps.

Damian.
 
Back
Top