How can I get a form to open another the current record displayed?

[Fii Asaber]

Hi,

I have a form with a command button which opens another. This second form
takes a few of its fields from the first form and has a subform. The first
form has a list of records activities (meetings) and the details of where the
event took place and the organization which hosted it. The second form has
the title of the meeting and the date and couple other fields, which are
locked and the subform has the list of people who attended the event.

What I am unable to do is having the command button in the first form open
the correponding record or current record I am viewing in the first form when
I click to open the second. This is to say that if I am viewing record number
10 in the first form when i click the button to open the second I'll like to
see the list of people who attended that meeting I am viewing in the first
form. What happens is that when I click the command button it shows the
attendees for the first meeting and I have to hit the next button until I get
to the tenth record to view my data.

Sorry for my long request. I am trying to make it as explanatory as possible.

I will very much appreciate your help with this.

Thanks Fii!

 

[Jeff Boyce]

It all starts with the data...

"How" depends on how your data is structured.

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP