how to code an IF statment

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Consolidation Table from Different Excel Tabs with Different Format 1
Getting Radio Buttons to work, that are inserted via AutoText 0
Need help modifying code 0
New computer, how do i move outlook 365 ENTIRELY? 0
If statment from msgbox responce 4
How do I set focus (and select text) on a text box on a modeless userform? 0
This code does not execute when I am choosing no 4
Populate main form from subform record 0

Top