the event code is as per your link
Code:
Private Sub Form_Click()
DoCmd.OpenForm "Bookings", , , "Booking_ID = " & Me.Booking_ID
End Sub
where 'booking_ID' is an autonumber field for the 'bookings' table
i have tried adding the 'acFormEdit' in as well but to no avail.
as my form is currently populated with all records ( i am sorting the filtering at them moment) i suppose it is logical that the number i am seeing passed through would match that of the record even if it were not the record number and is in fact the key field as you are suggesting.
how do i get the new form that is opening to show the record from the row on the datasheet that the user clicked. i thoughtr i may have to use a 'select' as the records have been filtered twice by the time the user clicks on it. Would this be right ?
sorry if i am not explaining to well
EDIT
i have just sorted the filtering out for the first tab, and it does indeed pass the correct Booking_ID to the event to open the form but the form moves to a new record entry instead of the existing one.
i have also examined the form properties in design view and the filter property shows the setting "Booking_ID=1839" which is the record number i selected.