Rather than closing and opening forms, it makes more sense to REQUERY
the forms based on the contents of your combo box. Look into the
RecordSource property of forms.
piscogirl@gmail.com wrote:
Quote:
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
