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 |
#31
|
|||
|
|||
Multiple Records
Ken
I was wondering if I could send you what I have for review. I am not getting the results that I should be with the subforms. It is showing 3 records for Director and 3462 for Officers and 3600 for shareholders...I am pretty sure that one company doesn't have that many shareholders. LOL. You would really help me out if you could review this and advise me of things that I have done wrong. Once I can figure out what I am doing wrong then I will be adding fields such as the addresses for the members and adding at least 3 searches (search by member name, company or sdc file number). |
#32
|
|||
|
|||
Multiple Records
Did you join the tables in a query as I suggested and open that to see if the
right officers, directors and shareholders were being returned per company? If so and the query's results look OK then the most likely source of the problem is that the subform and form isn't linked correctly. The LinkMasterFields and LinkChildFields properties of each of the three subform controls should be CompanyName. These are properties of the subform controls. A subform control is the control in the main form which houses a subform. I don't normally look at files on an individual basis, but as we've come so far with this and I suspect the problem will probably be not too difficult to identify I'll be happy to take a quick look at it. Mail it to me at the following (munged) address. If you are using a later version than Access 2002 be sure to convert the copy you send to 2002, as I'm still in the dark ages. My email address is: kenwsheridanatyahoodotcodotuk Ken Sheridan Stafford, England "pupkiss1965" wrote: Ken I was wondering if I could send you what I have for review. I am not getting the results that I should be with the subforms. It is showing 3 records for Director and 3462 for Officers and 3600 for shareholders...I am pretty sure that one company doesn't have that many shareholders. LOL. You would really help me out if you could review this and advise me of things that I have done wrong. Once I can figure out what I am doing wrong then I will be adding fields such as the addresses for the members and adding at least 3 searches (search by member name, company or sdc file number). |
Thread Tools | |
Display Modes | |
|
|