Custom Navigation - Multiple records

[tnago]

I have quite a number of records, as such I like to move next 10 or previous 10 record at a time to quickly go through them. I was unable to find anything which specifies how to navigate multiple records at a time. Also is there a way to jump to a specific record rather then going through Find and Replace option? Any help will be greatly appreciated.

 

[dcx693]

I'm sure there must be a clever way to move 10 records forwards or backwards, but the only idea I could come up with was to use a loop to execute the DoCmd.RunCommand acCmdRecordsGoToNext statement 10 times.

As for your second question, the answer is yes. If you explain your situation we can provide some help.

 

[tnago]

DCX693 thanks for your suggestion on the first part; below is some further explanation on the second part.

I have all records in a table tied to incident number field. What I am trying to achieve is that if a user wants they can select a specific record and view or update the record by putting the incident number. When I created the command button with find record option it opens Find and Replace dialogue box. I was wondering if there is a way to go to specific record without going through Find and Replace dialogue.

 

[jfgambit]

An an unbound textbox to your form called txtIncident and add the following to the after Update event of the textbox

Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[IncidentNumber] = " & me.txtIncident
Me.Bookmark = rs.Bookmark

HTH

 

[tnago]

Hi Jfgambit

I used the code however it is not selecting the new record. I just want to clarify wheather "[IncidentNumber] is column name or TableName.

Anyway that is how I have in the database.

Private Sub Text150_AfterUpdate()
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[IR] = " & Me.Text150
Me.Bookmark = rs.Bookmark

End Sub

Any suggestions?

 

[jfgambit]

1. Are you getting an error? If so, what type (error description)?

2. What is the data type of IR (Number, Text)??

 

[tnago]

Hi Jfgambit

Thanks for your help. The problem is resolved now.