Search results

Thanks for that - that should work really well. Any idea what I am doing wrong here?:

Hi I have a form with 10 check boxes. All put a value into different fields as they relate to different criteria. I need to filter via numerous combinations of check boxes (i.e. to find out which contacts have had a certain letters sent etc) and setting up reports for each one would not be...

Thanks so much for the info. Am almost there now - the link from company form to contact form works fine. However I have tried to put it in so that I can do the same from contact to company (i.e. when I am on a contacts details, I can click there company name and it goes to the company screen...

Hi Sorry to be a pain, but have one last problem (aside from the above one). Once these are done - i'll be all sorted! When I enter a contacts details, and there address into the address subform, is there a way I can do a drop down combo box for Address.Name which then brings up the address...

Hi Thanks so much for the reply. This is a task given to me in my new job and am struggling somewhat. I seemed to have got those bits working ok (it is the second option I went for) but still the following problem: on company form: I want to view a contacts details. I have set up a button...

Hi Thanks for the reply. I have CompanyID (from Company) linked to CompanyID (from Address) and then I have AddressID (from Address) linked to AddressID (from Contact). Is this right. I am not sure which join type they should be though. Thanks for the subform info. How do I do it for the...

Hi I wonder if anybody can help with this problem. I am setting up a basic contact list, with 3 tables - contact, address and company. What I want to do is be able to add numerous addresses to the company table/form. Then, when I add a contact, I can go to the contact form and select an...