Display Comments

[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

 

[Rick B]

Why not use a subform? This is a classic case of where a subform should be
used.

 

[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.

 

[Dirk Goldgar]

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.

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.

 

[Brent]

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

 

[Dirk Goldgar]

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

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.