Hi, I have a form with a command button which opens another. This second form takes a few of its fields from the first form and has a subform. The first form has a list of records activities (meetings) and the details of where the event took place and the organization which hosted it. The second form has the title of the meeting and the date and couple other fields, which are locked and the subform has the list of people who attended the event. What I am unable to do is having the command button in the first form open the correponding record or current record I am viewing in the first form when I click to open the second. This is to say that if I am viewing record number 10 in the first form when i click the button to open the second I'll like to see the list of people who attended that meeting I am viewing in the first form. What happens is that when I click the command button it shows the attendees for the first meeting and I have to hit the next button until I get to the tenth record to view my data. Sorry for my long request. I am trying to make it as explanatory as possible. I will very much appreciate your help with this. Thanks Fii!
Fii Asaber wrote: >Hi, > >I have a form with a command button which opens another. This second form >takes a few of its fields from the first form and has a subform. The first >form has a list of records activities (meetings) and the details of where the >event took place and the organization which hosted it. The second form has >the title of the meeting and the date and couple other fields, which are >locked and the subform has the list of people who attended the event. > >What I am unable to do is having the command button in the first form open >the correponding record or current record I am viewing in the first form when >I click to open the second. This is to say that if I am viewing record number >10 in the first form when i click the button to open the second I'll like to >see the list of people who attended that meeting I am viewing in the first >form. What happens is that when I click the command button it shows the >attendees for the first meeting and I have to hit the next button until I get >to the tenth record to view my data. > >Sorry for my long request. I am trying to make it as explanatory as possible. > >I will very much appreciate your help with this. > >Thanks Fii! I dont think you have set the subform criteria to pick up the record you want to see. They are not linking together. What you need to do is use the first form field (something unique) as the criteria for the subform. Something like [forms]![formname]![fieldname] as the criteria. I found list boxes work better than subform and easier to do. -- Message posted via http://www.accessmonster.com
It all starts with the data... "How" depends on how your data is structured. More info, please... Regards Jeff Boyce Microsoft Office/Access MVP "Fii Asaber" wrote in message news:C17F271F-9822-4491-AF42-B29D552E64A8@microsoft.com... > Hi, > > I have a form with a command button which opens another. This second form > takes a few of its fields from the first form and has a subform. The first > form has a list of records activities (meetings) and the details of where > the > event took place and the organization which hosted it. The second form has > the title of the meeting and the date and couple other fields, which are > locked and the subform has the list of people who attended the event. > > What I am unable to do is having the command button in the first form open > the correponding record or current record I am viewing in the first form > when > I click to open the second. This is to say that if I am viewing record > number > 10 in the first form when i click the button to open the second I'll like > to > see the list of people who attended that meeting I am viewing in the first > form. What happens is that when I click the command button it shows the > attendees for the first meeting and I have to hit the next button until I > get > to the tenth record to view my data. > > Sorry for my long request. I am trying to make it as explanatory as > possible. > > I will very much appreciate your help with this. > > Thanks Fii!
