populate combobox with difference two fields

[littleme]

Hello again. Am hoping once again that someone can point me in the right direction.

Have cascading comboboxes, which work fine. Only small hick-up...
Have a table with
fldSize fldMin fldMax

CboxSize allowes user to choose a Size.
What I then would like is for cboxLimit to populate with the all the values between fldMin and fldMax, including Min and Max.

It is this las bit I dont know how to do. I know how to populate with just the Min and Max values but how to all values in between, that arent actually found anywhere...

Am i being stupid?

 

[namliam]

You can retrieve the min and max values by using CboxSize.Columns(ColumnNumber)
0 is the first column, 1 the second etc.

Then use a For Next loop to loop thru Min to Max and fill your second combobox.
Quick sample on how to use a for next loop:

Dim I as Integer
For I = 1 to 5
    msgbox I
next I

Good luck!

 

[littleme]

Ah...ok. Thank you...

So in my case:
Dim I as integer
For I=Min to Max

Next I


I see how that would run through the values...how do i put them in the combobox?

 

[namliam]

Have a search on the forum...

"Filling Combobox" will return a few sample for you....