By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,680 Members | 1,578 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,680 IT Pros & Developers. It's quick & easy.

Help! subform vertical scrollbar problem

P: n/a
Hello there,

I have a main form frmOrder and inside a subform sbfrmOrderDetail. When I
add records from main form to subform, it is alright when the records don't
exceed 40 rows (the subform's height equils to the height of 40 rows), the
records are added Ok, but they are hidden, i.e, I have to use the subform
vertical scroll bar to see all the added rows after 40.

What can I do if I want every record added after 40 be at the bottom row of
the subform so that I can always see what was added right now.

Thank you for your help,

Paul
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
You can't scroll the form without changing the record. David and Stephen
Lebans have both provided workable solutions to your previous post.

"Paul T. RONG" <et***@hotmail.com> wrote in message
news:op******************@news.chello.at...
Hello there,

I have a main form frmOrder and inside a subform sbfrmOrderDetail. When I
add records from main form to subform, it is alright when the records don't exceed 40 rows (the subform's height equils to the height of 40 rows), the
records are added Ok, but they are hidden, i.e, I have to use the subform
vertical scroll bar to see all the added rows after 40.

What can I do if I want every record added after 40 be at the bottom row of the subform so that I can always see what was added right now.

Thank you for your help,

Paul

Nov 13 '05 #2

P: n/a
Base your subform on a query that includes the primary key in
TblOrderDetails. Sort the primary key descending. The most current records
will always be at the top of the subform list. When you add a record to the
subform, be sure to requery the subform which will make that record just
added appear at the top of the list.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Paul T. RONG" <et***@hotmail.com> wrote in message
news:op******************@news.chello.at...
Hello there,

I have a main form frmOrder and inside a subform sbfrmOrderDetail. When I
add records from main form to subform, it is alright when the records don't exceed 40 rows (the subform's height equils to the height of 40 rows), the
records are added Ok, but they are hidden, i.e, I have to use the subform
vertical scroll bar to see all the added rows after 40.

What can I do if I want every record added after 40 be at the bottom row of the subform so that I can always see what was added right now.

Thank you for your help,

Paul

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.