If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Command to open form
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 |
#2
|
|||
|
|||
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. -----Original Message----- 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 . |
#3
|
|||
|
|||
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. -----Original Message----- 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. -----Original Message----- 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 . . |
#4
|
|||
|
|||
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. -----Original Message----- 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. -----Original Message----- 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 . . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Strange stLinkCriteria behaviour on command button | Anthony Dowd | Using Forms | 3 | August 21st, 2004 03:01 AM |
Open a form from a record in Querry result or Table | David | New Users | 8 | July 23rd, 2004 11:29 PM |
Open form to blank record | Deb Smith | Using Forms | 1 | July 10th, 2004 03:46 PM |
Subform not open - but it is on open main form??? | Paula | Using Forms | 1 | June 7th, 2004 05:32 PM |
Form Doesn't Go To New Record | Steve | New Users | 15 | May 16th, 2004 04:33 PM |