set value

Hi,

Is it possible to have a field set the value of a drop-down field? If
status is "refused" I would like another field to be set to "not approached".
If status is anything else, I would like the user to be able to enter
"recruited" or "refused" from the drop-down field.

Hi Karen,

Of course... you just use the AfterUpdate event of the control and then set
the combo value as appropriate, eg:

if me.status = "refused" then
me.combo = "not approached"
else
me.combo = null
end if

Of course, the exact items depend on the settings of your combo box, eg: use
the ID field if you have an ID field being stored in the combo etc.

Hope this helps.

Damian.


"Karen" wrote:

Hi,

Is it possible to have a field set the value of a drop-down field? If
status is "refused" I would like another field to be set to "not approached".
If status is anything else, I would like the user to be able to enter
"recruited" or "refused" from the drop-down field.

I tried that and it works but it is not exactly what I want to do. I am
entering the board status on one form. When I open the school form, I want
school status to say "not approached" in a drop-down field if the board
status was "refused" (entered previously) If the board status is anything
else then I want the user to be able to enter the school status from the
drop-down field.

Thanks.

"Damian S" wrote:

Hi Karen,

Of course... you just use the AfterUpdate event of the control and then set
the combo value as appropriate, eg:

if me.status = "refused" then
me.combo = "not approached"
else
me.combo = null
end if

Of course, the exact items depend on the settings of your combo box, eg: use
the ID field if you have an ID field being stored in the combo etc.

Hope this helps.

Damian.


"Karen" wrote:

Hi,

Is it possible to have a field set the value of a drop-down field? If
status is "refused" I would like another field to be set to "not approached".
If status is anything else, I would like the user to be able to enter
"recruited" or "refused" from the drop-down field.