User Profile

Misab1984 · Mar 5 '14, 05:33 PM

Yaaa now its works !!!! thanks you maaan ,, !!!

Misab1984 · Mar 5 '14, 04:43 PM

this line is highlited :

Code:

StPassenger = Nz(DLookup("wantedName", "WantedList", "WantedName = " & Nz(Me.PassengerName.Value)))

and the value in Stpassenger is ""

Misab1984 · Mar 5 '14, 04:32 PM

Dear topher23,

thanks for your reply, I've copied and pasted your code in the database, where it was giving me the same runtime error 2001, msg: you cancelled the previus operations.

Misab1984 · Mar 5 '14, 03:44 PM

I've tried now as you informed me but its giving me error 2001, and msg; you cancelled the previus operations.

I've attached the sample database in the below link, could you please check and let me know,,

https://dl.dropboxusercontent.com/u/...Passengers.rar...

Misab1984 · Mar 5 '14, 02:32 PM

Thanks both for your reply!!,

actually i've did with the both function Dcount and Dlookup as following code:

Code:

Private Sub PassengerName_Exit(Cancel As Integer)
    Dim StPassenger As String
    
        StPassenger = DLookup("wantedName", "WantedList", "WantedName" = Me.PassengerName.Value)
        
        If StPassenger = True Then
            MsgBox "This

...

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

how to check a field from another table