Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Viewing all records in a subform

Status
Not open for further replies.

jackerman

IS-IT--Management
May 10, 2000
4
US
I have a main form with a subform which is supposed to display six rows of data (form view - not datasheet (from query)).&nbsp;&nbsp;When the form loads, it shows all six rows of data, but if you leave the cursor in the 2nd, 3rd, 4th, 5th, or 6th row and reload the subfrm, it (the subform) displays only those rows greater than and equal to the one where the cursor was placed (for example, if you place the cursor in the 3rd row, then reload the form, the only rows displayed are the 3rd,4th,5th,and 6th).&nbsp;&nbsp;Rows 1 and 2 are not displayed.&nbsp;&nbsp;The rows are not able to be viewed, but they are still there (if you shift+tab, focus moves up to the &quot;hidden&quot; rows.&nbsp;&nbsp;<br><br>I have tried to use the DoCmd.GoToRecord, ac first method (I've attached this to both the main form and the subform to the on change event in each form).&nbsp;&nbsp;This did not work.&nbsp;&nbsp;I have read all the relevant help info regarding this problem and have looked through numerous books and have still not come up with a work around.&nbsp;&nbsp;Any insight would be <br>greatly appreciated.<br><br>Thanks,<br>Justin
 
Sorry to mention the obvious, but is the vertical scroll bar at the right scrolled all the way to the top?
 
Elizabeth:<br><br>There actually is no scroll bar (because it's not displaying in datasheet view), but you can use the record selectors to go up to the first row.&nbsp;&nbsp;But because this is an application for an end user, I need to hide the record selector.<br><br>Thanks for replying
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top