list box with row values: 1-9999

[jguscs]

I'm trying to figure out how to have the default values for a list box automatically set by its row source from 1 to 9999.
I'm assuming that by setting its row source type to "value list" and coming up with some kind of simple code for a sequence to denote a list from 1 to 9999, that would do it.
On the other hand, VB is usually the way to go when it comes to this kind of stuff.
Any suggestions?

 

[dcx693]

You could do it using VB, but why would you want to? Why not just set up a text box where users could type in the number? Or set up a text box that is "attached" to a spinner control that will let users scroll through numbers?

 

[jguscs]

aha! yes, a "spinner," that's the word/concept i was looking for...
is there a spinner control in access? and if so, how would i attach it to a text box?

 

[dcx693]

Sorry, I don't, but the Access 2000 Developer's Handbook has a sample class module that comes on the CD-ROM.