Enforce a field type in after validation check

[anniebai]

I have this form to input a student's tuition source, after the source is entered as 'instate' or 'out', there's a checking on whether the student is a CA resident. If not from CA, and the source is set up as 'Instate', then a msgbox pop up and indicates the wrong input. (the code is attached below)

While the problem I get is, after click 'ok' on the msgbox, i don't know how to make it stays in the wrong field and checking until it get right, I used setFocus to the 'Source' field, but it doesn't work as I expected, since I can navigate to other fields with the wrong thing not changed. I've struggled a whole afternoon, but don't know where to find the right answer. Thanks in advance for any inputs!

Private Sub checkValid()
    If [Forms]![Students]!residentOf <> "CA" And Source Like "IN*" Then
        MsgBox "Cannot Using Instate source for a student out of CA"
        Source.SetFocus
    End If
End Sub
 
Private Sub Source_AfterUpdate()
    Call checkValid
End Sub
 

[Scott Price]

I have this form to input a student's tuition source, after the source is entered as 'instate' or 'out', there's a checking on whether the student is a CA resident. If not from CA, and the source is set up as 'Instate', then a msgbox pop up and indicates the wrong input. (the code is attached below)

While the problem I get is, after click 'ok' on the msgbox, i don't know how to make it stays in the wrong field and checking until it get right, I used setFocus to the 'Source' field, but it doesn't work as I expected, since I can navigate to other fields with the wrong thing not changed. I've struggled a whole afternoon, but don't know where to find the right answer. Thanks in advance for any inputs!

Private Sub checkValid()
    If [Forms]![Students]!residentOf <> "CA" And Source Like "IN*" Then
        MsgBox "Cannot Using Instate source for a student out of CA"
        Source.SetFocus
    End If
End Sub
 
Private Sub Source_AfterUpdate()
    Call checkValid
End Sub
 

Try qualifying your Source.SetFocus line... i.e. either Me!Source.SetFocus, or Forms![FormName].Source.SetFocus

Regards,
Scott

[anniebai]

Try qualifying your Source.SetFocus line... i.e. either Me!Source.SetFocus, or Forms![FormName].Source.SetFocus

Regards,
Scott

Scott,
Thanks for the fast reply. the setFocus works fine, problem is after it gets focused, it doesn't enforce me to correct it, i can use 'tab' button to navigate to some other fields and the error is still there.

Plus, i don't know how to reference the Source as you suggested. this field is under a subform called [StudensAndFunding subform]. the main form is called [Students]. So, I tried [Students]!Source, [Students]![StudentsAndFunding subform]!source and Me!Source, none of them worked. but if I use just the field name as in my code, it works just fine. What's the 'Me' in my case? I wasn't a VB programer and am new in Access, it frustrates me sometimes.

[FishVal]

Scott,
Thanks for the fast reply. the setFocus works fine, problem is after it gets focused, it doesn't enforce me to correct it, i can use 'tab' button to navigate to some other fields and the error is still there.

Plus, i don't know how to reference the Source as you suggested. this field is under a subform called [StudensAndFunding subform]. the main form is called [Students]. So, I tried [Students]!Source, [Students]![StudentsAndFunding subform]!source and Me!Source, none of them worked. but if I use just the field name as in my code, it works just fine. What's the 'Me' in my case? I wasn't a VB programer and am new in Access, it frustrates me sometimes.

Try to handle it in Source_Exit event setting Cancel=True if validation fails.

[anniebai]

Try to handle it in Source_Exit event setting Cancel=True if validation fails.

how and where to set the cancel=true?
thanks.

I found it. it worked great. thanks a million! it's such a wonderful forum!

[anniebai]

how and where to set the cancel=true?
thanks.

It's wonderful!!
i set cancel=true , and it worked as magic.

[Scott Price]

It's wonderful!!
i set cancel=true , and it worked as magic.

Glad it works, and we were able to help!

Welcome to TSDN.

Regards,
Scott

[FishVal]

how and where to set the cancel=true?
thanks.

Nice, you've made it work.

[Scott Price]

Scott,
Thanks for the fast reply. the setFocus works fine, problem is after it gets focused, it doesn't enforce me to correct it, i can use 'tab' button to navigate to some other fields and the error is still there.

Plus, i don't know how to reference the Source as you suggested. this field is under a subform called [StudensAndFunding subform]. the main form is called [Students]. So, I tried [Students]!Source, [Students]![StudentsAndFunding subform]!source and Me!Source, none of them worked. but if I use just the field name as in my code, it works just fine. What's the 'Me' in my case? I wasn't a VB programer and am new in Access, it frustrates me sometimes.

For your information, when referring to a control on a subform, the proper syntax is: Forms![MainFormName]![SubFormName].Form![ControlName]

In your case, Access was smart enough to recognize what you were referring to :-)

The Me![ControlName] is used when referring to a control on the form which has the code module that contains the code you are running.

Regards,
Scott