DLookup Function, statement in access

Hello friends , In this video tutorial I am going to show you that you can learn DLookup function statement in access.This is special function called DLOOKUP short for Domain Lookup , which lets you look up a value in a table or query for example showing you look up the Address, Contact and Email fields from StudentT table where the StudentID is the same as the StudentID on AdmissionT form or in this case , the value in Student Combo box since you are picking from a list.
Dlookup statement syntax-
equal DLookup left hand bracket Field Domain Criteria -Right hand bracket close
The field simply any field you want return the value
Domain is any table or query value
Criteria allows to tell Dlookup which record to return.
I hope you like this tutorial
Thanking you
For more Pls visit / mcitech
#dlookup#dlookupformaccess

[@yamoussasoumah8080]

Thank you so much you've solved my problem.

[@annandkoongie4513]

Thanks, it works for me

[@waqasmusani6531]

thanks for sharing great effort

[@SurajitG]

Thank you! Probably this can solve a very old problem of mine.

[@rakibulhasan8592]

We want to more video about the syntex of different function in visual code in access

[@hussainrly]

Your the best teacher

[@archanaaa2514]

Sir,, please make 1 videos on all type of functions in expression builders..

[@8deepak8sharma8]

Sir kisi tex box me sirf combo box se hi value enter kar sake manually nahi
Ye condition kese set hogi

[@JassMediaYouTubeTutorials]

Sir, do you full tutorial of dlookup function in query without combo box
with proper tables

[@newdigitalera9994]

Nice video sir

[@histographicevents771]

dlookup result in form didn't effect the admission table address email and contact?

[@aliabdulah4000]

Answer please.
Or if you would have refreshed the admission table that might have showed the data

[@kumargautam6997]

Thanx Guruji

[@kiranideal]

It only run for first record remaining records not working

[@newdigitalera9994]

Sir access me form design karke uske field name ka data type ksise change karege.
Plz reply sir

[@amans226]

Sir i have tried several times but failed, can you help me identifying the problem of my project.

[@helpoperationhealtheducati8411]

If you move so how will you see brother?

[@procurementproxy6290]

GCode = DLookup("[GCode]", "Godownlist", "GdName =" & GdName)
iam using this above mention function code but, this error was display syntax error (missing operator) in query expression "GdName = CWC"
pls give any suggestion

[@MCiTech]

GCode=DLookup("[GCode]", "Godownlist", "ID=" & GdName). ......ID >>TABLE ID .
.IF YOU COPY GCode from the table...There is different way to DLookup ..pls watch this tutorial...

[@MCiTech]

"" Ms access function-Dlookup,Dsum,DCount Function ""

[@josepablojuarezrivera4976]

IT DIDNT WORK :C, IT APPEARED A ERROR MESSAGE, BEING SPECIFIC IT IS ERROR '3075', COULD ANYONE HELP ME?

[@kiranideal]

Pls provide the database file for dlookup

[@kiranideal]

Should i unsubscribe if you are unable to reply

[@bdhis24]

bdhis24

[@RaajTechnical-ug1kb]

Sir kya 2010 me run nhi hota hai

[@MCiTech]

Hota hài

[@Thanogr1]

animation focus not good

[@ajayanandsharma7155]

kya tamasa hai