hockey8837
Registered User.
- Local time
- Today, 03:00
- Joined
- Sep 16, 2009
- Messages
- 106
I used the Microsoft students template to create a contact-event tracking DB.
I have 2 forms, Events Details and Contacts Details, which are pretty identical in function; open a contact record, and see all events to which they've attended in a subform in the 'events' tab, or open an Event record and see all contacts who attended that event in a subform on the 'Attendees' tab. (One-to-many relationships on both forms)
The original template had students and guardians; I changed these to become contacts and events. This template had the same 2 types of forms; Student Details and Guardian Details. However, this template only had the one-to-many relationship view ability on the Student Details form. So, you could open a student record and view relational Guardians, but couldn't open a Guardian and view any related students.
I added this missing feature to my Events Details form (the Student Details became the Contacts-so it already had it).
The function I'm having problems with is this:
If I'm in Student Details and type a guardian which is not currently in the DB, I get prompted with a window saying 'the text you entered isn't an item on the list. Do you want to edit the items in the list?'
If you click yes, it opens the Guardian form and it fills in the first and last name which was just typed in the subform on the Student Details for you. When the user finishes entering the new Guardian and closes, it updates this on the Student form perfectly.
How do I get this to function on my Event Details and my Contact Details forms? Because I changed some of the coding, the prompt only works for the Contact Details form, but doesn't fill in anything in the newly opened Event Detail form. It doesn't work at all when coming from the Event Details and trying to add a new contact to the DB.
I've attached the DB to try to clarify things...
I have 2 forms, Events Details and Contacts Details, which are pretty identical in function; open a contact record, and see all events to which they've attended in a subform in the 'events' tab, or open an Event record and see all contacts who attended that event in a subform on the 'Attendees' tab. (One-to-many relationships on both forms)
The original template had students and guardians; I changed these to become contacts and events. This template had the same 2 types of forms; Student Details and Guardian Details. However, this template only had the one-to-many relationship view ability on the Student Details form. So, you could open a student record and view relational Guardians, but couldn't open a Guardian and view any related students.
I added this missing feature to my Events Details form (the Student Details became the Contacts-so it already had it).
The function I'm having problems with is this:
If I'm in Student Details and type a guardian which is not currently in the DB, I get prompted with a window saying 'the text you entered isn't an item on the list. Do you want to edit the items in the list?'
If you click yes, it opens the Guardian form and it fills in the first and last name which was just typed in the subform on the Student Details for you. When the user finishes entering the new Guardian and closes, it updates this on the Student form perfectly.
How do I get this to function on my Event Details and my Contact Details forms? Because I changed some of the coding, the prompt only works for the Contact Details form, but doesn't fill in anything in the newly opened Event Detail form. It doesn't work at all when coming from the Event Details and trying to add a new contact to the DB.
I've attached the DB to try to clarify things...
