Subforms - accessing them via 'button'

[seasalt]

Hi

I run my own small business from home. At the moment I store all of my business contacts on a Access 2000 database. I am now trying to enhance this by adding a 'contact history' subform to the main 'contacts' form I use the subform to log phone conversations with customers, dates and details of letters that went out etc. My main problem is that I would like to be able to access the 'contact history' subform via a button on the main form and I cannot seem to make this happen. I can set in up for linked forms but not subforms. At the moment the subform appears over the main form which is a pest.

I have tried 'help' and a text book that enabled me to get this far but I can't seem to find what I am looking for. I sure this must be really obvious and I am sorry if this is not the right place to ask for this sort of help but if someone could possibly point me in the right direction I would be really grateful.

Thank you

 

[zzz]

The way we do it is by having a contact history subform on the contacts form. I was a little unclear what you were doing so sorry if I am repeating what you have already done.

tblContacts
ContactId - AutoNumber & PrimaryKey
and the rest of the fields you want.

tblContactHistory
ContactHistoryId - AutoNumber & PrimaryKey
ContactId - Number
and the rest of the fields you want.

After making the forms open the Contacts form in design view and shrink it so you can also see the database window then click and drag the SubfrmContactHistory form onto the contacts form where you want it. in the properties for the SubfrmContactHistory the Master & Child Linking Fields will be "ContactId" and that will bring up the contact History for only that contact. Like I said I was unclear why you wanted a button but, if it is because you do not have enough room on your Contacts form you shold make it a tabbed form and have the first tab be the contacts and the second tab be the Contact History for that contact.

 

[seasalt]

Hi
Thanks very much. That is really helpful. It has also cleared up a few issues I had with the creation of the form and the subform. Due to space shortage I think that will go for tab one being 'contact' and tab two being 'contact history. So, back to the book to work out how to make tabs! Just when I think I'm getting somewhere I am back to the start again!
Thanks Again