More then 1 values on subform

[melwester]

I have an IDnumber on my main form that I want to link the info to my
subforms that I have built under the Tab Control. I was using Popups last
week and found out how to build subforms under the Tab control. Much more
nicer this way.

In the table of (CTANotes) I sometimes have 2 or more records with the same
IDNumber with different dates attached. What this table is capturing is all
the data per doctor as to what was done and date of occurance. Each doctor
has an separate IDNumber. This same ID number is used on the main form that
shows the address, contact person.

For example of the Notes Table:
ID Comments Date
1034 Had checkup 6/3/05
1034 Went in for tests 5/30/04

The first line shows up find but I need to show the 2nd as well. I cannot
group each line as each row has a different date. I've tried continuous form
but that shows the entire table. I don't want this.

How do I get more then 1 line to show on the subform per IDNumber?

 

[Marshall Barton]

I have an IDnumber on my main form that I want to link the info to my
subforms that I have built under the Tab Control. I was using Popups last
week and found out how to build subforms under the Tab control. Much more
nicer this way.

In the table of (CTANotes) I sometimes have 2 or more records with the same
IDNumber with different dates attached. What this table is capturing is all
the data per doctor as to what was done and date of occurance. Each doctor
has an separate IDNumber. This same ID number is used on the main form that
shows the address, contact person.

For example of the Notes Table:
ID Comments Date
1034 Had checkup 6/3/05
1034 Went in for tests 5/30/04

The first line shows up find but I need to show the 2nd as well. I cannot
group each line as each row has a different date. I've tried continuous form
but that shows the entire table. I don't want this.

How do I get more then 1 line to show on the subform per IDNumber?

Change it back to a continuous form, but this time set the
subform control's Link Master/Child properties (probably to
the ID field).

 

[melwester]

OK that worked - Thanks.

Now when I view them there is a LOT of space between the 2. How do I get
that space out of there? We are talking more then 10 lines here.

 

[melwester]

Answered my own question as I got it working.

What I did - I went into the subform itself "sfrmCTANotes" & saw all the
space and moved the footer up to allow more records on a page. When I went
back to the tabs\subform on my main form I noticed that I got all the spacing
out.

Thanks again on the previous question.