Oh, you didn't tell him how long it would really take, did ya? Oh, laddie. You've got a lot to learn if you want people to think of you as a miracle worker.
This was one of the easier subjects for me to understand since the beginner series. I also believe that I will be able to apply DLookup to my tables & forms (as opposed to some of the past information that I don't use.
Thank you for letting me know this topic was more approachable for you, and that you see how DLookup can be useful in your work. Knowledge is like a toolbox, and it sounds like you just grabbed a shiny new wrench.
Thomas Gonder
@Reply 3 months ago
I like this DLookup trick Richard taught (somewhere):
If IsNull(tbx_53_CrtrID) Then tbxc_CrtrC = Null Else _
tbxc_CrtrC = Left$(DLookup("DispCD & ""; "" & Nm1 & ""; "" & Nm2 & ""; "" & Nm3 & ""; "" & Nm4 & ""; "" & Nm5 & ""; "" & Nm6", "tbl_4_Entity", "ID = " & Str(tbx_53_CrtrID)), 70)
I'm using it in places where I waant to show Primary data in a Foreign related form.
Thomas Gonder
@Reply 3 months ago
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Testimonials.
