Too long combobox

[Igor Kramarsich - EDIT]

Hello,
I simple not see solution to this problem.

I have one form with subform.
In form is define number of job, type of job, sector of organization and
date of job.
Subform is a query (as I need to made calculation every line) define by
number of job (what is connection with main form), person who made job, kind
of work and other.
Problem is that kind of work grow so much. From started around 10, now is
more of 40. To have simple combobox with 40 possibility is it too bad.
Kind of work is define in one table when is listed kind of work, money for
this work and sector when this work can be made.
I look how to present when in main form is define (and must be define) a
sector that than in subform in column of kind of work, combobox show just
work what can be made in this sector and not all.

Any suggestion will be great. I try lot of possibility but no one with
success

Igor

[Salad]

Igor Kramarsich - EDIT wrote:

Hello,
I simple not see solution to this problem.

I have one form with subform.
In form is define number of job, type of job, sector of organization and
date of job.
Subform is a query (as I need to made calculation every line) define by
number of job (what is connection with main form), person who made job, kind
of work and other.
Problem is that kind of work grow so much. From started around 10, now is
more of 40. To have simple combobox with 40 possibility is it too bad.
Kind of work is define in one table when is listed kind of work, money for
this work and sector when this work can be made.
I look how to present when in main form is define (and must be define) a
sector that than in subform in column of kind of work, combobox show just
work what can be made in this sector and not all.

Any suggestion will be great. I try lot of possibility but no one with
success

Igor

Are you using a continuous form? If so, you will run into some
problems. The combo box will need to have the same values for it for
each record. Otherwise all values will appear to be the same as you
change the recordsource.

If this is the case, you might want to "pop-up" and edit form with you
are in the subform to edit the data. Maybe in a field in the subform
allow the op to dbl-click on the field and it pops up the form to edit
some of the data. I think that is the best method...if you are using a
continuous form.