how to code an IF statment

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

Access 2003 & Access 2007
I want to code the "after update" event of a Yes/no box on a form.

if the answer is NO Is there an "After Update" just by tabbing past it?

if the answer is no I want to change the focus to a different tab on the
same form form

Forms!frmStudy.pgeNoGo.SetFocus

If the answer is YES I do not want to do anything

I am just not sure of the syntax of the IF statement in VBA

Any help here will be appreciated.

Thanks in advance
dave
 
Back
Top