Arrow down - up causing move between records

[John M]

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

[Jeff Smith]

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

[Hugh Webster]

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/