clicking through from record to record on form

mat41 · January 6th, 2009, 07:58 PM

I have a bound form which is used for inserting records and viewing existing records. If I open an existing record I want to be able to click the forward and back buttons at the foot of the form to move from record to record, how can I do this???

I didnt build the form and have limited access from experience. Presently when I open a record I do see:

Record: (back arrow) and (forward arrow)

on the bottom however the back button is grayed out and I am only allowed to clik forward which clears the form and alllows me to enter a new record only.

-----------------updated info:
I have been researching this and am fast coming to the conclusion a bound form can not use the record navigation, or at least this one cant. SHould I be able to???

May I add this to the scenario - When I open the form as if I am entering a new record the navigation works. However if I open an exisitng record it does not. I have even turned off the navigation and using controls created my own. This also works and fails in the same way described.

Any ideas???
-----------------------------

TYIA

mmcdonal · January 8th, 2009, 12:56 PM

It sounds like the form is being opened in different ways. When you open to an existing record, it sounds as if the form is being opened with only one record in the recordset. It also sounds like when you open the form to add a record, it opens it with all the records, but shows you a new record / blank form.

Can you post the code used to open the form for each case? I think the issue here is not the navigation buttons, but how you are opening the form.

You can add buttons using the button wizard, and one of the wizard parameters is to add navigation buttons as you describe.

mat41 · January 8th, 2009, 05:47 PM

This is the code behind the Event Procedure which is fired after:

a.. a text box asks for an ID number to open an existing record
b.. the open Record button is clicked

Private Sub Command28_Click()
On Error GoTo Err_Command28_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "FRM_Support_Call1"

stLinkCriteria = "[Ref]=" & Me![Combo26]
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_Command28_Click:
Exit Sub
Err_Command28_Click:
MsgBox Err.Description
Resume Exit_Command28_Click

End Sub

And this is the code in the same scenario however this is for a new record where the navigation works

a.. Open New Call button is clicked.
b.. As seen in the code below Macro ("MCR_Opn_Frm_Call") is called. It contains three lines:
- Minimize (the active window)
- Open Form is the next one which opens the form 'FRM_Support_Call1'
- now GoToRecord is the third line (the form 'FRM_Support_Call1' is in the Object prperties of goToRecord )
c.. Now the form opens and the navigation works:

Private Sub Command8_Click()
On Error GoTo Err_Command8_Click
Dim stDocName As String
stDocName = "MCR_Opn_Frm_Call"
DoCmd.RunMacro stDocName
Exit_Command8_Click:
Exit Sub
Err_Command8_Click:
MsgBox Err.Description
Resume Exit_Command8_Click

End Sub

This is really bugging me I have spent several hours trying to figure this out now.

TYIA

mmcdonal · January 9th, 2009, 08:26 AM

So there are your issues:

The first event opens the form with only one record in it, so you will not be able to use the navigation buttons.

The second event runs a macro, which you did not attache, so I am not sure what is going on there. It probably opens the form and gives you all the records, but moves to a new record first.

You can simply create a button to open the form normally, and all your navigation buttons will work. There is no problem with your code or forms or the nav buttons. Everything is doing what it is supposed to do.

Try this code on a new button:

Dim sDoc As String

sDoc = "FRM_Support_Call1"

DoCmd.OpenForm sDoc

Or use the other form name MCR_Opn_Frm_Call. They are probably copies of the same form, just with different recordsets.

Did that help?