Combo Box

[desireemm via AccessMonster.com]

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

Weekly_hrs 40 Hours = 2 parent family Month 173
Weekly_hrs 30 hours = single parent child over 6 years Month 130
Weekly_hrs 20 hours = sigle parent child under 6 years Month 87
Weekly_hrs 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

 

[KARL DEWEY]

I think I follow so here is an alternate solution.
Create a Family_Hours table like this --
Auto - Autonumber - primary key
Weekly_hrs - number
Parents - number
ChildAge - number
Month_hrs - number

Source for combo --
SELECT Auto, Weekly_hrs & " " & Parents & " " & ChildAge & " " &
Month_hrs FROM Family_Hours;

Fill table with all possible combination, in the order user would expect to
fill blanks on a form.

Use After Update event of combo to set value from Family_Hours table based
on Auto field of combo.

 

[desireemm via AccessMonster.com]

Here is what I have I created a table called the Family_Hours and how its
suppose to look is when there is a
this is the type of family and due to how many chidren they have and if dad
is at home then that determines how many hours they are responsible for per
week and month

Two Parent Family - Weekly Hours = 40 Montly Hours= 173
so this is how I put the data in the table

1 Single Parent w/child 1 to 6 yrs 20 87 NULL
2 Single Parent w/child 6 yrs & up 30 130 NULL
3 Two-Parent Family 40 173 NULL
4 Non-Needy 0 0 NULL
5 Disregarded 0 0 NULL
6 Exempt 0 0 NULL


the users wants to choose what kind of family it is then have the hours
automatically pop up in the drop down. I hope that makes sense??

I think I follow so here is an alternate solution.
Create a Family_Hours table like this --
Auto - Autonumber - primary key
Weekly_hrs - number
Parents - number
ChildAge - number
Month_hrs - number

Source for combo --
SELECT Auto, Weekly_hrs & " " & Parents & " " & ChildAge & " " &
Month_hrs FROM Family_Hours;

Fill table with all possible combination, in the order user would expect to
fill blanks on a form.

Use After Update event of combo to set value from Family_Hours table based
on Auto field of combo.

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

[quoted text clipped - 20 lines]

then the correct hours would pop up instead of the user having to constantly
type them in. any suggestion would be appreciated

 

[desireemm via AccessMonster.com]

Here is what I have I created a table called the Family_Hours and how its
suppose to look is when there is a
this is the type of family and due to how many chidren they have and if dad
is at home then that determines how many hours they are responsible for per
week and month

Two Parent Family - Weekly Hours = 40 Montly Hours= 173
so this is how I put the data in the table

1 Single Parent w/child 1 to 6 yrs 20 87 NULL
2 Single Parent w/child 6 yrs & up 30 130 NULL
3 Two-Parent Family 40 173 NULL
4 Non-Needy 0 0 NULL
5 Disregarded 0 0 NULL
6 Exempt 0 0 NULL

the users wants to choose what kind of family it is then have the hours
automatically pop up in the drop down. I hope that makes sense??

I think I follow so here is an alternate solution.
Create a Family_Hours table like this --

[quoted text clipped - 19 lines]

I am trying to make one combo box populate another, when the user chooses
TypeofParticipant combo box(which is the family types) then their instead of
them choosing the Monthly Hours and Weekly hours that are required for that
family, the combo boxes would jsut be populated for them. but they would be
based on the type of family

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