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

Continuous Form Record Display Issue

P: n/a
I am using a continuous form for display purposes.

Above this form, a single record is displayed so that when the user
presses my NewButton they can enter a NewRecord which gets added to
the continuous form that displays below.

Under the NewButton I have these lines of code:
Me.AllowAdditions = True
DoCmd.GoToRecord , , acNewRec

The problem is that the continuous form I use for display purposes,
refreshes and only displays the New blank record while the user is
entering the New data in the single record above. I would like for
the continuous form to display not only the NewBlank record being
added, but the records that exist above it. If I click on the
VertBar, the form refreshes, to display exactly what I wanted.

How can I get this in code without having to excite the VertBar???

Feb 11 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Feb 11, 5:41 pm, "ApexD...@gmail.com" <ApexD...@gmail.comwrote:
I am using a continuous form for display purposes.

Above this form, a single record is displayed so that when the user
presses my NewButton they can enter a NewRecord which gets added to
the continuous form that displays below.

Under the NewButton I have these lines of code:
Me.AllowAdditions = True
DoCmd.GoToRecord , , acNewRec

The problem is that the continuous form I use for display purposes,
refreshes and only displays the New blank record while the user is
entering the New data in the single record above. I would like for
the continuous form to display not only the NewBlank record being
added, but the records that exist above it. If I click on the
VertBar, the form refreshes, to display exactly what I wanted.

How can I get this in code without having to excite the VertBar???


How large is the detail section of the continous form?
What can sometimes happen is that when the new record is created and
the display space is relatively small, Access forces the new record to
be at the top of the display space, so that a few more records can be
added without having to scroll. When the display space is larger this
'forced scrolling' happens less frequently.

Feb 12 '07 #2

P: n/a
Thank you for responding

The display space is only 7-records. And the current table is only
holding 9-Records.
This seems to be in line with your comment. I guess I should just
leave it alone!

Greg
Feb 12 '07 #3

P: n/a
On Feb 11, 8:54 pm, "ApexD...@gmail.com" <ApexD...@gmail.comwrote:
Thank you for responding

The display space is only 7-records. And the current table is only
holding 9-Records.
This seems to be in line with your comment. I guess I should just
leave it alone!

Greg


Someone with a little more experience may have a way of preventing the
upwards scrolling, but I haven't found one, nor have I worried about
it very much. If you need to indicate that there are more records
above (some people do wonder where they've gone as though scroll bars
have never existed before) you could always put some kind of notice in
the forms head section.

Feb 12 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.