dawsonrhodes
Member
- Local time
- Today, 05:37
- Joined
- Mar 8, 2020
- Messages
- 85
Hey All,
This may be very easy, or very difficult, I'm not entirely sure.
Basically, there is a user form that is filled out as a regulatory obligation for every transaction completed. These records require some personal information, and based on this information collected (first, last, date of birth, address), it can later be found in another form, where it gets treated as a "profile" for each person.
Currently, the form is build as a subform in a parent form (the "profile"), which means that in order to make a record, the user first has to search for the "profile" (with information such as name, dob, etc.) to then add the form.
What I'd like to do is automate this, as there are some other reasons I need this that I won't include, as they aren't relevant. The user form would be something like what's listed below
What I would like to do is automate the entries, so that if txtFirstName, txtLastName, txtDateofBirth match, it will automatically record the other fields into a new record for that "person"
I'm not sure if this is clear, please let me know if I need to clarify anywhere.
Thanks in advance!
This may be very easy, or very difficult, I'm not entirely sure.
Basically, there is a user form that is filled out as a regulatory obligation for every transaction completed. These records require some personal information, and based on this information collected (first, last, date of birth, address), it can later be found in another form, where it gets treated as a "profile" for each person.
Currently, the form is build as a subform in a parent form (the "profile"), which means that in order to make a record, the user first has to search for the "profile" (with information such as name, dob, etc.) to then add the form.
What I'd like to do is automate this, as there are some other reasons I need this that I won't include, as they aren't relevant. The user form would be something like what's listed below
First name | Last Name | DOB |
Address | ID Number (D2933-23842-38746 | ID Type (Drivers License) |
Transaction Amount ($00.00) | Exchange Rate ($00.00) | Method Funds Issued (in person, cheque) |
What I would like to do is automate the entries, so that if txtFirstName, txtLastName, txtDateofBirth match, it will automatically record the other fields into a new record for that "person"
I'm not sure if this is clear, please let me know if I need to clarify anywhere.
Thanks in advance!