[MS_AccessPros] Re: Help with VBA

 

Hello Ken

You should really start a new thread when you have a new question, instead of tacking on a reply to an old thread.

You can check if a field is empty (null) by using the IsNull function, and you "goto" a given control using the SetFocus method:

If IsNull( Me![filed A] ) Then

    Me![Filed C].SetFocus

Else

    Me![filed B].SetFocus

End If

Best wishes,

Graham [Access MVP 1996 - 2016]

---In MS_Access_Professionals@yahoogroups.com, <kenaf42@...> wrote :

If filed A has no value (Empty) the go to Filed C ealas goto filed B

Thank you- Ken 

__._,_.___

---

Posted by: graham@mandeno.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (16)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

SPONSORED LINKS

.

__,_._,___