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

Arrow down - up causing move between records

P: n/a
Hi,

I have a form which I would like to keep in 'FormView', but which displays
rows each containing records. Generally the data will be added/updated by
moving between fields, but I would also like the down arrow to move down a
record and the up arrow move up a record etc. Darned if I can see how,
despite searching through the help - both Access and Visual basic.

Thanks in advance

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


P: n/a
Hi John

It's obvious that your form is a continuous form which the default behaviour
for the down arrow with this type of form is to move to the next field.

Solution:
In the Form's properties, select the Event tab and change the "Key Preview"
to "Yes". In the Form's "On Key Down" event type the following code

If KeyCode = vbKeyDown Then
DoCmd.GoToRecord , , acNext
End If

You might want to do a similar one for the up arrow too.

Jeff
"John M" <jo**@jmawer.demon.co.uk> wrote in message
news:ci*******************@news.demon.co.uk...
Hi,

I have a form which I would like to keep in 'FormView', but which displays rows each containing records. Generally the data will be added/updated by
moving between fields, but I would also like the down arrow to move down a
record and the up arrow move up a record etc. Darned if I can see how,
despite searching through the help - both Access and Visual basic.

Thanks in advance

Nov 13 '05 #2

P: n/a
When you say FormView but with rows containing records, I assume you mean
Continuous Forms.

In that view, Up/Down works ok - until you input or change a data field.
When that happens you have to use enter or tab to move to the next field.

You could write some code in the KeyUp/KeyDown event to force a move, but
try using a DataSheet view instead.

On Sun, 12 Sep 2004 10:52:25 +0100, John M <jo**@jmawer.demon.co.uk> wrote:
Hi,

I have a form which I would like to keep in 'FormView', but which
displays
rows each containing records. Generally the data will be added/updated
by
moving between fields, but I would also like the down arrow to move down
a
record and the up arrow move up a record etc. Darned if I can see how,
despite searching through the help - both Access and Visual basic.

Thanks in advance


--
Using Opera's revolutionary e-mail client: http://www.opera.com/m2/
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.