access account
Registered User.
- Local time
- Today, 04:33
- Joined
- Jun 4, 2012
- Messages
- 14
Hi! I am incrediably new to forms and Access 2003 (thank you for the advice on formatting!).
I've run into a problem with the command buttons on one of my forms. I have a main form that has a command button that opens up a second form. On the second form my Record Navigation 'go to previous record' and Record Navigation 'go to next record' buttons do not work, I receive the error: You can't go to the specified record.
However, when I open this second form up by itself these buttons function as they should.
@AccessMSSQL mentioned that when I open the second form through the command button, this may be because I have something set to only display one record so I can't move to the next or previous.
If this is the case, would someone be able to help me find a way to get the Record Navigation buttons to work as they should if I open the second form through the command button on the main form?
The code I have for the previous Record Navigation button on the second form is:
Any help would be greatly appreciated- thank you so much!
I've run into a problem with the command buttons on one of my forms. I have a main form that has a command button that opens up a second form. On the second form my Record Navigation 'go to previous record' and Record Navigation 'go to next record' buttons do not work, I receive the error: You can't go to the specified record.
However, when I open this second form up by itself these buttons function as they should.
@AccessMSSQL mentioned that when I open the second form through the command button, this may be because I have something set to only display one record so I can't move to the next or previous.
If this is the case, would someone be able to help me find a way to get the Record Navigation buttons to work as they should if I open the second form through the command button on the main form?
The code I have for the previous Record Navigation button on the second form is:
Code:
Private Sub Previous_Disease_Condition_Button_Click()
On Error GoTo Err_Previous_Disease_Condition_Button_Click
DoCmd.GoToRecord , , acPrevious
Exit_Previous_Disease_Condition_Button_C:
Exit Sub
Err_Previous_Disease_Condition_Button_Click:
MsgBox Err.Description
Resume Exit_Previous_Disease_Condition_Button_C
End Sub
Last edited: