move cursor within table without mouse

[amerifax]

I am trying to find a way when I am in a record and I might have the following:
name-address-city-phone-

I am might be in phone and want to go to address, with out using mouse. I also might want to go to the start of the record, name or start new record and be in the name postion with the new record. All with out a mouse.

In dbase IV I could do all this wit a "PRG" file.

I'm sure Access can do the same buy how. I already know it can be done. But where to enter the code and what is the code.

Bob

Can this also

 

[maxmangion]

Hi,

not sure i understood you question correctly but have you tried the directional arrow keys (up, down, left and right) and also the Tab Key.

Moreover, i wouldn't recommend you edit data directly from a table but you should be doing that at form level.

 

[amerifax]

I'm bring in data fropm another source. The posision of the cursoe is not alway in same location. So I need to get it to the home position of the active record.

Botom line I need to move around the record without the use of a mouse.

Example: In some editing programs if I do a control Home I will end up in the first field of the record. Control Home don't work in Access. What will?

Bob

 

[WayneRyan]

AmericaFax,

I don't make a habit of navigating without a mouse, but you could use the form's KeyDown
Event and write a little code to set focus to some desired field as a result of Key-Strokes.

You could use Me.ActiveControl.TabStop and increment/decrement. You can easily trap user-
entered Key-Strokes.

Need more info, or just search here (or Google) for KeyDown.

Wayne

 

[Rich]

Searching for shortcut keys can be really helpful
http://www.joyedaniels.com/keys_access.htm