Op-up window to verify correct User Id

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BG44 - 24 Apr 2008 21:14 GMT

In an old Db3 application, the Client info was entered in one table. When we
opened the first form to begin data entry, upon entering the Client ID, a
message would pop up showing the name and address of the Client, with the
question, Is this the correct client? We checked yes and went on to enter
information in the form. This was just a safety measure to make sure we
didn't get client info mixed up.

Could someone give me an idea where to start this process in Access 2003?
Thanks.

Reply to this Message

Klatuu - 24 Apr 2008 22:22 GMT

You could use a message box:

If MsgBox "Is Client " & Me.txtClientName & " the correct Client",
vbQuestion + vbYesNo) = vbYes Then
'Go ahead and do it
Else
'Do something different
End If

Signature

Dave Hargis, Microsoft Access MVP

> In an old Db3 application, the Client info was entered in one table. When we
> opened the first form to begin data entry, upon entering the Client ID, a
[quoted text clipped - 5 lines]
> Could someone give me an idea where to start this process in Access 2003?
> Thanks.

Reply to this Message