Showing all comments when CBO Selection is made

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!
 
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!!
Click to expand...

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]
 
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.
 
Back
Top