DLookUp function in MS Access forms. DLookUp in Access forms
This Video explains the application of DLookUp function in MS Access forms.DLookup Function. In Access desktop databases you can use the DLookup function to get the value of a particular field from a specified set of records (a domain). Use the DLookup function in a Visual Basic for Applications (VBA) module, a macro, a query expression, or a calculated control on a form or report.
Function for Student Name
=DLookUp("[S_Name]","Students","[Students].[ID]=" & Str([Combo0].[Text]))
Function for Student Age
=DLookUp("[S_Age]","Students","[Students].[ID]=" & Str([Combo0].[Text]))
Function for StudentAddress
=DLookUp("[S_Address]","Students","[Students].[ID]=" & Str([Combo0].[Text])) DLookUp in Access forms