ajitaccess
New member
- Local time
- Today, 14:06
- Joined
- Feb 24, 2015
- Messages
- 8
Hello All
I have a request application made in Access 2016, it has following tables
tblRequestMain
-ID
-FirstName
-LastName
-Designation
-RequestDate
-Request
-Remarks
tblPersDetails (this holds data for personnels and serves lookup for above table)
-ID
-FirstName
-LastName
-Designation
Two Forms
1. frmRequestMain (with fields above in table tblRequestMain plus field FirstName also has a Search button which opens frmPersDetails)
2. frmPersDetails
- Listbox - lstSearch
-Textbox - txtSearch and button which populates lstSearch
Now what i am trying is to automatically populate FirstName, LastName & Designation fields on frmRequestMain by double clicking row on lstSearch.
Can anyone help with the code please.
Thanks
I have a request application made in Access 2016, it has following tables
tblRequestMain
-ID
-FirstName
-LastName
-Designation
-RequestDate
-Request
-Remarks
tblPersDetails (this holds data for personnels and serves lookup for above table)
-ID
-FirstName
-LastName
-Designation
Two Forms
1. frmRequestMain (with fields above in table tblRequestMain plus field FirstName also has a Search button which opens frmPersDetails)
2. frmPersDetails
- Listbox - lstSearch
-Textbox - txtSearch and button which populates lstSearch
Now what i am trying is to automatically populate FirstName, LastName & Designation fields on frmRequestMain by double clicking row on lstSearch.
Can anyone help with the code please.
Thanks