Command to open form

[Nicol]

I have a contact management database
I have a table called meetings.
I want to put a command on the Contacts form to open the
meetings form for the staff to add meeting information.
There is a primary key in the contacts table contactid
So I thought I could link the contact and meeting table
via contact id..but when i try to add the command button
and say bring only these records and then try to link
contact id...It is not on my list of choices for the
contact table.
I am so confused here.
All I want to do is have the staff be able to open the
contacts form..click on a meetings icon and put
information in..But I want it to show info for that
person only..so I know I need to link
them...Confused..sorry I will explain if someone wants to
tackle this one...
Nicol

 

[Bruce]

If I understand correctly what you need to do, I think you
can accomplish it by having the form based on the Meetings
table be a subform of the Contacts table. The command
button could make the subform control visible. If the
primary key from Contacts is a foreign key in Meetings it
should work. Easiest way of making a subform is probably
to open the main form (frmContacts)in design view, then
drag the icon for the other form (fsubMeetings) onto the
main form. Check back if you need more details, or if
this is completely off the tracks.

 

[Guest]

Thanks..I was able to create the subform for meetings on
the contacts form. But do I actually have to see it when
the contacts form opens. I kind or wanted just a command
button that would open the meetings instead of showing
the meetings form.

 

[Nicol]

Thanks..I was able to create the subform for meetings on
the contacts form. But do I actually have to see it when
the contacts form opens. I kind or wanted just a command
button that would open the meetings instead of showing
the meetings form.