Another Conditional Macro Question

  • Thread starter Thread starter Suze
  • Start date Start date
S

Suze

Hi,

I submitted this question recently:
I want to have the focus sent to a specified field after
the current field is updated, but the field I want to
send the focus to will depend on what is entered in the
current field. IsNull and IsNotNull are not sufficient.
The info entered is chosen from a drop down list, so will
always read the same. How do I write this macro
Click to expand...
please ??

And got this reply:

Use a GoToControl action for each option, and in the
Condition for each
of them, put an expression to show the value, for
example...
[NameOfYourCombobox]="fred"
Assign the macro on the After Update event of the
combobox.

--
Steve Schapel, Microsoft Access MVP

Which was perfect advice, thanks, but now I realise that
I want to know what I would put if the condition was that
anything BUT fred is entered?

Thanks in advance
 
Back
Top