Re: Showing all comments when CBO Selection is made

Tech-Archive recommends: Speed Up your PC by fixing your registry

The subform is a continuous form so I'm good there. The Child and Master
links are "TopicID" and the record source is "tblTopicComments". Again, when
a user opens the form and selects a project from the drop down, I want all
the information that was enter under that project name to appear. any help
would be appreciate as I am an access amature so I will need the procedure
kind of spelled out. Thank you for you patience.

"John Vinson" wrote:

> On Thu, 18 Aug 2005 13:50:07 -0700, Doug_C
> <DougC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>
> >Hello,
> >
> >On my form, I have a subform that user input comments. Each time the user
> >goes to a new record and select a project name, How do I get all the comments
> >previous made under that project to show in the sub form? In otherwords after
> >a week, users may have entered 20 comments for that project. Each time that
> >project is selected I would like all previous comments to show so each user
> >can see everything at once on the subform rather than pulling reports. If
> >this makes sense, I would appreciate any assistance.
> >
> >Thanks!!
>
> Simply use a Continuous Subform. If there are more comments than will
> fit on the screen (how loquacious are your users?), there'll be a
> scrollbar.
>
> If you have a continuous subform already - what are the Recordsources
> of the main and sub forms? What are the Master and Child Link Fields?
>
> John W. Vinson[MVP]
>
.

Relevant Pages

  • Re: Another Form-Subform problem
    ... Try conditional formatting. ... Microsoft Access MVP ... I have a Form and a "Continuous Subform". ... on the sub form whose value matches with that on the main form ...
    (microsoft.public.access.formscoding)
  • Re: Unbound continuous subform
    ... You can create a form with 4 rows of text boxes that simulates a continuous subform. ... Tips for Access users - http://allenbrowne.com/tips.html ... I have a sub form and the columns are unbound. ...
    (microsoft.public.access.formscoding)
  • Another Form-Subform problem
    ... I have a Form and a "Continuous Subform". ... fields (not the master-child) on both the main and the sub forms. ... on the sub form whose value matches with that on the main form ... Where should I raise the event? ...
    (microsoft.public.access.formscoding)