Refreshing a subform to show newly entered data

[Nick F]

I have a form for entering information on events that we have participated in. I have a tabbed section that has information for partners (subform based on Event_Partners table) we work with on a particular event (first name, last name, organization, etc., etc.). I want to show which partners have already been entered. I figured the easiest was putting in another subform based on the Event_Partners table but in Datasheet view. This one only shows name and organization and not all the other information located on the first subform. I want this lower subform to update/refresh after each piece of information (first name, last name, organization) is entered in the above subform. I can't seem to get it to work. If I close down the mainform or leave the mainform and comback, it shows up nicely. I want it to show up immediately. Any suggestions?

[ssanfu]

Refresh or requery the subform???

Use the after update event of the three controls (first name, last name, organization)??

[Nick F]

I have tried

Forms!Event_Main!Event_Partners1_subform.Requery - Doesn't seem to do anything
Forms!Event_Main!Event_Partners1_subform.Refresh - gives me an error message

[RayMilhon]

Assuming that the main form is for a specific Event and the subform is a list of the attendees for the specific Event Link the main form to the subform on the Event When you change the event the subform will automatically change to the attendees for this event. For this to work correctly you need 3 tables. 1 for the Events 1 for the attendees and 1 linking table between the 2 Sample structure:

Table Event
EventID
Eventdescription
Eventdate

Table attendees
AttendeeID
AttendeeName

Table eventattendees
EventID
AttendeeID

[Nick F]

Assuming that the main form is for a specific Event and the subform is a list of the attendees for the specific Event Link the main form to the subform on the Event When you change the event the subform will automatically change to the attendees for this event. For this to work correctly you need 3 tables. 1 for the Events 1 for the attendees and 1 linking table between the 2 Sample structure:

Table Event
EventID
Eventdescription
Eventdate

Table attendees
AttendeeID
AttendeeName

Table eventattendees
EventID
AttendeeID

Thank you for the reply. I think I am on the right track. I created a junction table like you mentioned above. The third table has three fields EventPartnerJunctionID (autonumber), Event_ID, Partner_ID. I linked this table to the Event table using the Event ID and to the Partner table using the Partner ID. Please excuse my elementary questions. Now how do I show the information in my form. I have attached a screen shot. When I hit add record, I would like the name that I have just entered to show up in the blank spot beneath the partner entry form. Thanks.

[RayMilhon]

In the data properties of the subform you should see Link Master Fields, Link child Fields. To the right of Link Master Fields should be EventID. To the Right of Child Fields should also be EventID. This will link the subform to the Main form so that when the record in the main form is changed the subform will also be changed.
The only think I would change is in the Junction table you don't need the autonumber. Assuming that you will have 1 partner linked to 1 event you can use the EventID and PartnerID Fields As the Primary key for that table the autonumber would just be wasting space as you would never use it for anything.

[RayMilhon]

should have been thing not think. typing too fast for my brain to catch up.

[Nick F]

should have been thing not think. typing too fast for my brain to catch up.

I couldn't figure out how to get the junction table to function how I wanted. I did find another method. Thank you for taking the time to help me. It was much appreciated.