Go to specific record!

[ice-9]

Hi,

I have a problem.
I have a subform that is a datasheet
on the left i have a subform that is a continuessubform.
When the user presses the button on the left, in the continuesform, i want that the datasheet goes to that record. I do want that al other records are displayed, i just want it to go to the specific record.
I tried some stuf with recordsetclone, but this is just a clone and doesnt affect the real record.

can someone help me? please?

Joost

 

[ice-9]

Hi,

I have a problem.
I have a subform that is a datasheet
on the left i have a subform that is a continuessubform.
When the user presses the button on the left, in the continuesform, i want that the datasheet goes to that record. I do want that al other records are displayed, i just want it to go to the specific record.
I tried some stuf with recordsetclone, but this is just a clone and doesnt affect the real record.

can someone help me? please?

Joost

please advise

 

[ice-9]

not posible ?

 

[workmad3]

not sure on this myself. Have you tried setting the modified recordset clone back as the recordset of the form though?

 

[ice-9]

not sure on this myself. Have you tried setting the modified recordset clone back as the recordset of the form though?

Can i get the recordset of the form without cloning it ?

 

[workmad3]

I dont think you can get a forms recordset without it being a clone. But Im fairly sure what you can do is get the recordset clone, make modifications to it, and then set it back to the form as its actual recordset.

 

[pacg]

Hi Ice

Try this!

Dim strParentDocName As String

On Error Resume Next
strParentDocName = Me.Parent.Name

If Err <> 0 Then
GoTo Form_Current_Exit
Else
On Error GoTo Form_Current_Err
Me.Parent![FORM NAME].Requery

 

[ice-9]

Hi Ice

Try this!

Dim strParentDocName As String

On Error Resume Next
strParentDocName = Me.Parent.Name

If Err <> 0 Then
GoTo Form_Current_Exit
Else
On Error GoTo Form_Current_Err
Me.Parent![FORM NAME].Requery

sorry i dont really understand where to put it, or what it does? please advise!

 

[ice-9]

so easy

omg, this was so easy.
just used a find and a bookmark.
send te form to your bookmark and your done!
Here is the code:

Dim rs As Recordset
Dim Test As Integer
Dim varBookmark As Variant
Set rs = Forms!minutesinvoer!InvoerenActieDetails.Form.RecordsetClone
rs.FindFirst ("MinutesCode = " & Forms!minutesinvoer!ActionListSF![MinutesCode])
varBookmark = rs.bookmark
Forms!minutesinvoer!InvoerenActieDetails.Form.bookmark = varBookmark