Problem with getting Subform Text

[JimUK]

I am using 2 tables: ETR and LOG. The main form I am using shows all records from tblETR and 1 record from tblLOG. The record from tblLOG (tblLOG.Action)is displayed in a subform. My problem is that the subform record pulls separate LOG text entries on a particular Electronic Trouble Report (ETR). There can be many Log text entries per day on a single ETR.
I can pull one record to the subform no problem. WHat I need to be able to do is cancatenate all the text records together for a specific ETR and display them in the subform.

Like I said subform now displays the first and only one of the text entries for an ETR. If I change subform view to datasheet it shows all the entries, but I need to have subform show in form view to make it blend in with the rest of the form.

Any Ideas?

Jim

 

[danvlas]

Maybe your subform's Default View is set to Single Form and it should be Continuous forms...Check the properties.

Good luck


Daniel Vlas
Systems Consultant

 

[JimUK]

Yup it was. Now the problem is that the text has all kinds of white space between it now. I enable the vertical scroll bar only so all text can be read but, way too much space between them now. This is going to be something silly again I presume

Jim