Hello,
I am a novice Access 2007 user.
I am working on a form that registers new training attendees. One of the fields in my form asks for dealer number.
I have a separate table where all the dealer information is stored. One of the fields is a Customer Number field
I want to ensure that entries in the Dealer Number textbox on my New Registration form matches a valid Customer Number in the Dealer Database Table
I would like this verification to occur either upon a Click event with a button or on an After Update event.
Any help would be great.
Thanks!
I am a novice Access 2007 user.
I am working on a form that registers new training attendees. One of the fields in my form asks for dealer number.
I have a separate table where all the dealer information is stored. One of the fields is a Customer Number field
I want to ensure that entries in the Dealer Number textbox on my New Registration form matches a valid Customer Number in the Dealer Database Table
I would like this verification to occur either upon a Click event with a button or on an After Update event.
Any help would be great.
Thanks!