If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
set value
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. |
#3
|
|||
|
|||
set value
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. |
Thread Tools | |
Display Modes | |
|
|