View Full Version : Bypassing several fields


nia44
12-11-2000, 11:12 AM
Hom may I , as an example, jump from field 8 to say field 14 if field 8 has no data in it that is required. example if field 8 is do you have a telephone? and the answer is no or just blank, then it makes no sense to go to phone number but rather to field 12 which is "city". hope someone can help. I am rather new at this so need all the help I can get.

Jack Cowley
12-11-2000, 11:45 AM
In the After Update event of the telephone field you could put code similar to this:

If IsNull(Me![Phone]) Or Me![Phone] = "No" Or Me![Phone] = "" Then
Me![City].SetFocus
End if

[This message has been edited by Jack Cowley (edited 12-11-2000).]