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

[@fdmewan1]

Hey why u use old version of access in 2020.¿

[@RakeshSharma-cx5uh]

Can we DLookUp in subform and store the data in a table which is a child table of an parent table

[@selflearner6088]

Yes.I will send the link

[@RakeshSharma-cx5uh]

@@selflearner6088 This will be a great help... Thank