amna
05-28-2002, 04:36 PM
Hi,
Can some one help me with Dlookup function.
Actually I want to look up for two fields.
for example, in my table Log Record , I have two fields, WInumbers and names.
Now when ever user enter information from data entry form, like, name and workinstrustion number, then it should look up in the table to see, if that person already view that Work Instruction or not.
I am using this Dlookup function on my click event, but don t know what s wrong with that.
If (Dlookup( [WInumber] , [Log Record] , [Names] = & [Combo23] & )) Then
MsgBox You cannot view that slide , vbCritical,
Else
MsgBox yes you can have an access
End If
when I click on button for look up, then it gives me an error message, that out of stack space and type mismatch.
can some one help me with this.
Thanks in advance
Can some one help me with Dlookup function.
Actually I want to look up for two fields.
for example, in my table Log Record , I have two fields, WInumbers and names.
Now when ever user enter information from data entry form, like, name and workinstrustion number, then it should look up in the table to see, if that person already view that Work Instruction or not.
I am using this Dlookup function on my click event, but don t know what s wrong with that.
If (Dlookup( [WInumber] , [Log Record] , [Names] = & [Combo23] & )) Then
MsgBox You cannot view that slide , vbCritical,
Else
MsgBox yes you can have an access
End If
when I click on button for look up, then it gives me an error message, that out of stack space and type mismatch.
can some one help me with this.
Thanks in advance