navigation button query

[fayez_MrExcel]

I created a unbound form that has a combox with a series of id numbers that when a user choose from it the system will take the values from my Empmaster table which is perfectly okay. My problem is my navigation button, i created below syntax but it doent go to the next record, instead it goes to my message "This is the Last Record". What seems to be the problem. How can i set that the Empmaster table is going to be used to navigate. thanks

Private Sub cmdGoNext_Click()
On Error GoTo Err_Go2Next_Click

DoCmd.GoToRecord , , acNext

Exit_Go2Next_Click:

Exit Sub

Err_Go2Next_Click:

If Err.Number = 2105 Then
MsgBox "This is the Last Record"
Else
MsgBox Err.Description
Resume Exit_Go2Next_Click
End If

End Sub

 

[SydneyGeek]

If you want to be able to browse the records, the form must be bound to the table or query.

An unbound form only displays one record at a time; very useful if you have lots of users so you cut down network traffic. Less useful if you only have one or two users.

Denis

 

[fayez_MrExcel]

we have an approximate of 10 users.

 

[SydneyGeek]

As I said before, an unbound form can usually only show one record.

If you need to be able to browse, you will have to build custom navigation buttons to do it. Assuming that your combo pulls in a record based on an ID, you will have to create a Next button that passes the next ID to the combo and requeries the form. The Previous button will have to pass the previous ID to the combo and requery the form.

Denis

 

[fayez_MrExcel]

thank you sir, if it is not too much can you give me an example of next button syntax i have already created a combo box that pulls in a record based on an ID. thanks