Alex Motilal
New member
- Local time
- Today, 11:58
- Joined
- Jul 7, 2021
- Messages
- 15
This is my first post in this Forum.
I am creating a Family Tree Database. tblPersons contains the fields, PersonID, FirstName, MiddleName, LastName , Gender & relevant Dates & data.
Persons are added in the Main Form which contains a Subform where Children are added related to the PersonID on the Main Form.
The Main Form contains two Combo Boxes where the Mother & Father can be selected. If not in the tblPersons, it can be added through Not In List Event.
What I need is that when the Mother Combo Box or Father Combo Box are double clicked, the Main form should show the PersonID of the mother or father, so that other data such as dates can be entered.
I also want when the PersonID in the Sub Form is double clicked, the main form should display that persons data.
I request experts to provide me the VBA code for both the actions.
Alex
I am creating a Family Tree Database. tblPersons contains the fields, PersonID, FirstName, MiddleName, LastName , Gender & relevant Dates & data.
Persons are added in the Main Form which contains a Subform where Children are added related to the PersonID on the Main Form.
The Main Form contains two Combo Boxes where the Mother & Father can be selected. If not in the tblPersons, it can be added through Not In List Event.
What I need is that when the Mother Combo Box or Father Combo Box are double clicked, the Main form should show the PersonID of the mother or father, so that other data such as dates can be entered.
I also want when the PersonID in the Sub Form is double clicked, the main form should display that persons data.
I request experts to provide me the VBA code for both the actions.
Alex