auto fill if blank or manual change

[Guest]

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!

 

[Joseph Meehan]

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.