Navigate through multiple forms

[Steven811]

Hi

I have a form made up of a parent and 4 subforms and I want to use one set of navigation buttons that work where ever the cursor is positioned, I believe this is called focus.

Can anyone help.

I searched through the archives and can't see anything that helps.

Rgds

Steve811

PS - Using 2K

 

[Steven811]

Still searching for set focus help

I'd be really grateful for some help, I'm desperate.

 

[mohammadagul]

use the access builtin toolbar to navigate through the records.. i have tried and it navigates for all the main and subform

 

[Steven811]

Nav bar

The form, one parent and 4 subforms is littered with nav bars if I use Access's own. That is why I created my own nav bar.

I have had a search aroung and I have seen mention of 'active form' but I'm unsure how to include this in my button code.

Any ideas?

 

[mohammadagul]

I believe this is what you are looking for

Move To PreviousRecord
Moves to the previous record. Put behind a button called cmdPrevious.
'***************** Code Start *******************
'This code was originally written by Terry Wickenden.
'It is not to be altered or distributed,
'except as part of an application.
'You are free to use it in any application,
'provided the copyright notice is left unchanged.

Private Sub cmdPrevious_Click()
On Error GoTo ErrPrevious
DoCmd.RunCommand acCmdRecordsGoToPrevious
Exit Sub
ErrPrevious:
Select Case Err
Case 2046
'Command not available
MsgBox "You cannot goto the previous record as you are on the first record." , vbInformation, "Not Available"
Case Else
MsgBox Err.Number & ":-" & vbCrLf & Err.Description
End Select
End Sub
'****************** Code End ********************

 

[Steven811]

Code

Thanks, I'll have a go with that.

The only thing I was expecting to see was a reference to the form/field the cursor is in at the time that I use the cmd button.

Steven811