If not null copy to another text box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have three fields called Type, Keyword and Code

If the field TYPE says Email, I would like CODE to say whatever is in the
field KEYWORD.

If the field TYPE is empty or says something other than Email, I would like
to enter the contents fo the field CODE manually.

Can anyone help? Thank you.
 
Hi,
if you enter data via form - then you can use textbox Type AfterUpdate event
to fill textbox CODE:

if me!Type="Email" then
me!Code=Me!Keyword
else
me!Code.SetFocus
end if
 
Back
Top