Help with combo box selection based on text box

[Damonunit]

Hey guys,

I'm new around here, so please be forgiving. I have a text box in a form that a user can enter a particular year in (i.e. 1992) and then just below that I have a combo box for the decade. While the text box is free entry, the decade is set up to:
?
<1950


1950-1959
1960-1969
1970-1979
1980-1989
1990-1999
and so forth. What I would like to do, is to have the year text box determine the decade that will be selected, so that when a user enters 1992, the decade automatically enters 1990-1992.

If someone can help me with this, I'd be greatly appreciative.

Thanks,
Damon

[Perceptus]

So if your enter 1992 into the 1992 into txtBox1. and you want txtBox2 to display 1990-1992. you could do
txtbox2 = cint(txtbox1/10) * 10 & "-" & txtbox1

or something like that I think.