Buy Dideo Subscription
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 www.youtube.com/c/MCiTech #dlookup#dlookupformaccess
