subform doesn't show all records

[Guest]

I've got a subform that has a table as its record source, and a mainform
which has a query as its record source. An unbound text box is set up on the
mainform to filter the underlying query and thereby limit the results in the
subform. It works pretty well. The problem is that the subform link to the
mainform limits the results to only one record. There is navigation control
that I can use to scroll through all the query results, but I'd rather see
them all in a continuous subform view. Can somebody tell me how to do this?

 

[Guest]

In the design view of the form click on the small black square in the top
left hand corner. Go to the "format" tab. In the default view change it to
"continuous view" and change "views allowed" to form.

 

[Guest]

Hey scubadiver,

I believe that you may have misunderstood (or, more likely, I was unclear).
What I need is a continuous view of the subform, not the mainform. I have
the subform set up for continuous view, but apparently the master/child link
limits my to only one value at a time. Since my mainform is based on a
query, and I filter that query based on the value I input into a textbox, I
get a range of values for my mainform. But the relationship of a subform to
a mainform is many to one, not one to many, so I'm not sure if what I want is
even possible. But what winds up happening is that Access picks a value from
the recordset of my query and uses that as the master link for my subform. I
guess I was wondering if anyone knew of a way to get around the specific
requirements of the link property of the subform control and create something
a little less specific, sort of like a non-equi join in a query.

 

[Guest]

"the relationship of a subform to a mainform is many to one, not one to many".

It is more usual to make the main form the "one" side and the subform the
"many" side. That is why your subform is only showing one record! Think about
it!

 

[Guest]

Yep. You're right. I believe we're saying the same thing.