Combo Box with multiple columns

[desireemm1]

Hi guys I am trying to simplfy things for the users by putting information in a list box or combo box.

Heres what I'm trying to do

40 Hours = 2 parent family Month 173
30 hours = single parent child over 6 years Month 130
20 hours = sigle parent child under 6 years Month 87
0 hours = child under 1 year Month 0


right now its set up as three fields one is a combo box that has
"Single Parent w/child 1 to 6 yrs";"Single Parent w/child 6 yrs & up";"Two-Parent Family";"Non-Needy";"Disregarded";Exempt"



but I want the users to be able to choose one and then the hours will be there instead of them having to go to two seperate fields Called . Also these options are always tied together in a one-to-one sort of way

Mo 173 Wkly 40


does that makes sense i would like for them to choose the family and then the hours required pops up for that family. whether they be 2 parent or 1 parent then the correct hours would pop up instead of the user having to constantly type them in. any suggestion would be appreciated

[dcrake]

"Single Parent w/child 1 to 6 yrs";"Single Parent w/child 6 yrs & up";"Two-Parent Family";"Non-Needy";"Disregarded";Exempt"

Should read

"Single Parent w/child 1 to 6 yrs";"40";"Single Parent w/child 6 yrs & up";"30";"Two-Parent Family";"20";"Non-Needy";"10";"Disregarded";"10";Exempt";"10"

Then in the properties of your combo box set your column count to 2
column widths to 5cm,0cm

Set column 1 to be the bound column

Then on the AfterUpdate Event of the combo

Me.HoursField = Me.ComboBox.Column(1) (zero based)

David