conditions in a form

[Nicawette]

Hi all,

I've a form in access, in this form I have a combo box which refers to
table/query "priority" with the values : urgent, normal... and I have a
text box "name" in the same form. I would like when the priority is
"urgent" to add in the text box "name" a specific name and if normal
nothing in it. how can I simply do that?

Thank you for your help

Nic

 

[ruralguy via AccessMonster.com]

Assign the value of your TextBox in the AfterUpdate event of the ComboBox.
Hopefully the name of your TextBox is *not* "name". If it is, that is a poor
choice and should be changed. Here's some links you may wish to review.
http://support.microsoft.com/?id=286335
http://support.microsoft.com/?id=321266
http://support.microsoft.com/?id=826763

 

[Nicawette]

hi rural guy thank you for your answer and I haven't assigned the name
"name" ;-)

nice day

 

[ruralguy via AccessMonster.com]

Nice day back at you. Is your name the Nicotine gum as spoken by Elmer Fudd?
<g>