Hi I haven't found anything quite like what I'm trying to do. I have a form
where people fill out basically management objectives. It goes like this,
area, objective, sub area, objective. calculations are done on the objectives
for either area or sub area. in most cases the objectives are the same for
both the area and the sub area, but occasionally they are not. what I would
like is for when the person selects the first objective for the second to
auto fill with the same objective but also for the person to have the option
of manually changing it. I need to make sure neither of these are left blank.
right now the box has an expression of : select obj from ojb codes order by
obj

Can you help?? This is frustrating me to no end!!

Thanks!

Stephanie wrote:
> Hi I haven't found anything quite like what I'm trying to do. I have
> a form where people fill out basically management objectives. It goes
> like this, area, objective, sub area, objective. calculations are
> done on the objectives for either area or sub area. in most cases the
> objectives are the same for both the area and the sub area, but
> occasionally they are not. what I would like is for when the person
> selects the first objective for the second to auto fill with the same
> objective but also for the person to have the option of manually
> changing it. I need to make sure neither of these are left blank.
> right now the box has an expression of : select obj from ojb codes
> order by obj
>
> Can you help?? This is frustrating me to no end!!
>
> Thanks!

On the form you could use an "on focus" event of the second field to
copy the first field's data to it. You also could set the two fields as
required in the table.

--
Joseph Meehan

Dia duit