Quick key to move cursor to same field in next record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a quick key to move the cursor to the same field in the next record,
in a form?
 
Define "same field"...

Do you mean to always start in the same field (you can do this by setting
the tab order)?

Or do you mean to start in what ever field you were in in the previous
record?
 
The latter - whichever field I was in in the previous record. It's a library
database, with various tick-box fields. The user needs to be able to get
quickly to the same field in the next record - but this may be a different
field for different tasks, so doing it by setting the tab order wouldn't work.

Thanks

Richard
 
Richard

Sorry, but I'm still having trouble visualizing what you are doing. If, as
you say, the user needs to be able to get to the same field in the next
record, but it may be a different field, how do you resolve this?

Can you provide an example using real/imaginary data?
 
Jeff,

OK, it works like this. It's a music library, so for each music score there
may be up to 100 copies. Each copy has its own entry, so the form consist of
a header form for the item title, with a subform showing each individual copy.

The subform has fields for Date Entered, Date Repaired, StockCheck,
Reshelved and others., some of which are date fields, some tick boxes. When a
set of scores is returned to the library, the librarian needs to go down the
list and Press Ctrl-; to put today's date in the Stock Check field. So it
would be helpful to have a quick key to get straight to the Stock Check field
in the next record, to save pressing tab several times, or clicking the mouse
at the start of the field.

However, on another occasion, the librarian might be wanting to put data
into all the Reshelved fields, for example. So then the quick key woudl need
to move to that field.

Does this clarify things?

Thanks for your time.

Richard
 
Richard

Now I understand better the form you are using.

What I still don't see is the underlying data structure. Depending on how
you've organized your entities, attributes and relationships, you may be
able to take better advantage of Access' features & functions. I'll
encourage you to visit (?re-visit) your data structure, with an eye toward
normalization.

From a generic standpoint, one way to do what you've described would be to:

* track every field your user updates (perhaps by noting the name of the
control in an application-level variable from each control's AfterUpdate
event)
* In the form's OnCurrent event, go to the control named in the variable,
or, if none, to a designated "first control" ala Tab Order)

JOPO (just one person's thoughts)
 
While I agree with Jeff that there are probably better ways to do this kind
of thing, the key you are looking for is the Page Down key. On a single-page
form, this will go to the next record, leaving the focus on the same
control. Page Up will go to the previous record. Ctrl+Page Down will go to
the last record, and Ctrl+Page Up will go to the first record.

Assuming, of course, that there is no code in the Current event procedure to
change the focus.
 
Thanks, Brendan. Now that you remind me, I recall using that ...

Jeff Boyce
<Office/Access MVP>
 
Yes, I can see that would be a possible way forward. Not sure I have enough
programming knowledge to do it (I'm not a programmer). But thanks for your
help.

Richard
 
Back
Top