Subform doesn show all records in recordset

[dle4d]

Hello -

I have a subform that shows all records in my database. I have a Find
button that allows a user to search for specific records in the database and
load them into the the subform (the subform shows the records in datasheet
view). This worked beautifully until I upgraded to Access 2007. For some
reason that I cannot explain, the subform now does not show all of the
results from the search. It now only shows the first record returned. I
have verfied that the recordset for the subform still contains all of the
records found. I have been searching for a solution to this issue for
several months but cannot find anything helpful. Anybody have any idea what
I need to do in order have the subform display all of the records in the
recordset?

Thanks.

 

[Tom van Stiphout]

On Sun, 25 Jan 2009 17:23:01 -0800, dle4d

You must have some of the properties set incorrectly. Compare your
subform with that of a sample application that is working normally,
and you should be able to figure it out.

-Tom.
Microsoft Access MVP

 

[dle4d]

Do you know where I can find such a sample? I've searched with Google and
cannot find a similar sample. My Find form essentially creates dynamic SQL
that then is used to create a recordset for the subform. I have verified
using the VBA debugger that all the records are in the recordset. The
subform just doesn't want to show more than the first record in the
recordset. This was working fine in Access 2003. When I upgraded to Access
2007, the problem started. I have made absolutely no changes to any
properties. Any other thoughts? Thanks.

 

[Tom van Stiphout]

On Mon, 26 Jan 2009 21:29:01 -0800, dle4d

Open Access. Select OfficeKey > New
The Northwind sample application comes to mind.

-Tom.
Microsoft Access MVP

 

[Larry Linson]

If your Subform contains a Form, check that Form to see if it got changed
from Continuous Forms view to Single Form view.

There are some who would argue that a move from Access 2003 to Access 2007
is not an "upgrade".

Larry Linson
Microsoft Office Access MVP