Elookup

REALOLDMAN

New Member
Joined
Feb 5, 2019
Messages
12
I am trying ELoolup and I saw BTW I am self taught
with the exception of help by sites like this
I'm gratful
why ELookup because it gives error msg DLookup no
so
THIS WORKS OUTSIDE A SUB PROC but not a Proc IE:: ELookup
It worked before I changed code but I do dumb things
TblL = "Msdl"
TblH = "Msdh"
RkT = "ML"
RL = DLookup("PCT", TblL, "RkT = [RkT] ")
RH = DLookup("PCT", TblH, "RkT = [RkT] ")


HERE "COMPILE ERROR ByRef argument type missmatch
does not like tblL or tblH
RL = ELookup("PCT", TblL, "RkT = [RkT] ")
RH = ELookup("PCT", TblH, "RkT = [RkT] ")
The table has 2 fields RkT & PCT


I looked at all the ELookup posts and they seem to involve a function
and were complex
do I need a function to return the table byRef?
I understood useing ByRef was not good usally
Thank you
 

ranman256

Well-known Member
Joined
Jun 17, 2014
Messages
1,816
I think your syntax is wrong....maybe:
DLookup("PCT", TblL, "[RkT] = 'RTK'")

the last param is the FIELD in brackets, then the value around quotes.
 

REALOLDMAN

New Member
Joined
Feb 5, 2019
Messages
12
ok that was stupid of me did not ck cut & paste
still the func works outside of the sub but not in
 

Forum statistics

Threads
1,085,651
Messages
5,384,931
Members
401,926
Latest member
healthguy

Some videos you may like

This Week's Hot Topics

Top