Hi all,
Here's my case:
I have a form: Event Form
and a subform: AttendanceSubForm
The user selects a name (from a Person Table) on the subform to
register for the event. If the name is not there, they are to click a
command button (which is currently placed on the form) to open up the
Person Form.
Once the person is added, the Person Form is closed. However, the name
list on the subform is not refreshed.
My approach is to make the control button to open the Person form also
close the Event Form and AttendanceSubForm. Then, when the Person form
is closed, use a specific button that also reopens the Event form and
Attendance Subform.
The only problem is that I don't know how to get back to the Event
Record I was previously working on. I can't use last added record: If
I base it on the Event Form, I get the last added event. If I base it
on the subform, I have to open it first, and it opens in it's own
window. And, what if I haven't added anyone to that Event yet anyway?
So...
Either - Can anyone give me ideas about how to open the last viewed
Event Record
Or - Does anyone have another way to approach the problem?
Thanks a billion! (An American billion, to boot! Points if you know
the difference.)
- Melissa