Another Conditional Macro Question

[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

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

 

[Steve Schapel]

Suze,

[NameOfYourCombobox]<>"fred"