Display Comments

  • Thread starter Thread starter Brent
  • Start date Start date
B

Brent

I have a form that displays data on work order information. I would like
to put a box on this form that will display all of the comments for that
work order that are stored in a separate table called tblcomments. Is
there a way to pull all of the records from the comments table and combine
them into a single display box without using subforms? Any help is greatly
appreciated.


Brent
 
I was just looking for a cleaner way of viewing the data rather than having
another form in the detail section of my existing form.
 
Brent said:
I was just looking for a cleaner way of viewing the data rather than
having another form in the detail section of my existing form.
Click to expand...

I agree with RickB that this is really subform functionality, but if you
really want something else just to display the comments, you could use a
function like the fConcatChild() function posted here:

http://www.mvps.org/access/modules/mdl0004.htm

as the controlsource of a calculated text box, to return a concatenated
list of all the comments. It will be slow, though.
 
Can I add a subform to the details section of an existing form? sorry for
the basic questions but unfortunately that is my skill set. Thanks for all
of your help

Brent
 
Brent said:
Can I add a subform to the details section of an existing form?
sorry for the basic questions but unfortunately that is my skill set.
Thanks for all of your help
Click to expand...

Yes, you can, *provided* that the main or parent form -- the one you'll
be adding the subform to -- is in single-form view. You can't display a
subform on a continuous form.
 
Back
Top