navigation for records with buttons

[waqas]

dear experts. i have two questions.



1. how can i make my own navigation buttons for next, previous, first and last record.

2. i want to update changes in existing record and these changes i want to update as new record in another table how can i make in form.

kindly guide me.

[Missinglinq]

As to your first question, I think each Sub is self-explanatory:

Private Sub Go2New_Click()
  DoCmd.GoToRecord , , acNewRec
End Sub

Private Sub Go2First_Click() 
  DoCmd.GoToRecord , , acFirst 
End Sub

Private Sub Go2Last_Click()
  DoCmd.GoToRecord , , acLast 
End Sub

Private Sub Go2Prev_Click()

  If Me.CurrentRecord = 1 Or Me.CurrentRecord = acNew Then

	DoCmd.GoToRecord , , acLast

  Else
  
	DoCmd.GoToRecord , , acPrevious

  End If

End Sub

Private Sub Go2Next_Click()

  If Me.CurrentRecord = Me.RecordsetClone.RecordCount Or Me.NewRecord = True Then
 
	DoCmd.GoToRecord , , acFirst

  Else

	DoCmd.GoToRecord , , acNext

  End If

End Sub

If you get to the end of the Recordset, hitting Next or Previous 'wraps' it to the First Record or the Last Record, respectively. If you don't want this behavior you can use these Subs to
do nothing if on the First Record or Last Record, or pop a Messagebox telling the user the situation and then do nothing.

Sorry, but I have absolutely no idea of what you're asking in your second question!

Linq ;0)>

[waqas]

thanks linq,

my second questions is, i have master detail form and i want to insert a new record in detail form which user make change in master form.

like an employee has designation "Driver" from 01-01-07 to 31-01-09 in detail form now if user change his designation in master form it should insert a new record in detail form with new position and date of effect date.

how can i do?