set bookmarks on main and subform

Hi Bridget. You have not set a value for your second Recordset - rst (a confusing choice of name when the other one is called rs) - hence the object not set error. Because of the missing Set statement you have not actually cloned the subform's recordset at all so far.

I'm not sure that when you fix all this it will do what you want it to do, as subforms are normally bound to a value in the main form, which I think will work against trying to go to a specific record in the subform using recordsetclone, but feel free to experiment here!

-Stewart

Thank you for your response, Stewart. I realized the error in not having set a value for the second recordset after posting this. Duh! (and yes, rs vs rst is not very clear - I switched it to "rsm" and "rss" for rs main and rs sub respectively - not much better, but...)

Unfortunately, I still get an error. I'm wondering the same thing as you, whether or not its possible to do a double bookmark - one for a form and another for the subform... I will keep experimenting and post if I come up with a solution. In the mean time, if anyone has other ideas of how I can go to a specific record on a subform of a specific record on a main form, let me know!!
thx
Bridget

You could always use Public Variables initialized in the btnDone_Click() Event to store relevant values in both the Main and Sub-Forms, then use a pair of DoCmd.FindRecords to navigate to the correct Record in first the Main, and then the Sub_form.

Thanks for the idea, ADezii! I will give this a try.

Bridget

Hello all,
Before trying ADezii's idea, I gave the bookmark idea one more try and... I got it to work! (amazing - I almost feel like I'm starting to get this. At least until the next hiccup!)

I'm posting the code for people's reference. (A huge thank you to Allen Browne - I was able to use a suggestion made by him on another website and adjust it to make it work for me)

The code below is to set two bookmarks, one on a main form and the second on a subform on the main form. The code is called from the OnClick event of a Pop up form (opened by clicking on a button on the main form). The code first captures the current record (BldgID) from the main form and bookmarks it. Then it captures the current record (ContactIID) from the popup form and bookmarks this record on the main form's subform.
I hope it is of use to others.
Bridget

Expand|Select|Wrap|Line Numbers

1. Private Sub btnDone_Click()
2.  
3. 'start error check.
4. On Error GoTo Err_btnDone_Click
5.  
6. 'list variables
7. Dim rs As DAO.Recordset
8. Dim strWhere As String
9. Dim strMain As String
10. Dim strPopUp As String
11.  
12. 'FIRST FIND RECORDSET IN MAIN FORM:
13.  
14. 'capture the BldgID from the main form.
15. strWhere = "BldgID = " & Forms!frmTabs.txtBldgID
16.  
17. 'define the main form variable.
18. strMain = "frmTabs"
19.  
20. 're-open the main form.
21. DoCmd.OpenForm strMain
22.  
23. 'set recordset clone on the main form.
24. Set rs = Forms(strMain).Recordset.Clone
25.  
26. 'find record that matches stored ID.
27. rs.FindFirst strWhere
28.  
29. 'set bookmark on main form to the record that matches the stored ID.
30. Forms(MainFrm).Bookmark = rs.Bookmark
31.  
32. 'clear the recordset variable.
33. Set rs = Nothing
34.  
35. 'SECOND FIND RECORDSET IN SUBFORM:
36.  
37.  
38. 'capture the ContactID from the sub form.
39. strWhere = "ContactID = " & Me.txtContactID
40.  
41. 'set recordset clone on the main form's subform.
42. With Forms!frmTabs.frmTabContacts.Form
43.   Set rs = .RecordsetClone
44.  
45. ''find record that matches stored ID.
46.   rs.FindFirst strWhere
47.      .Bookmark = rs.Bookmark
48. End With
49.  
50. 'define the pop-up form variable.
51. strPopUp = "frmEditContactNm"
52.  
53. 'close the pop-up form.
54. DoCmd.Close acForm, strPopUp
55.  
56. 'Exit the sub
57. Exit_btnDone_Click:
58.     Exit Sub
59.  
60. 'Exit the error check.
61. Err_btnDone_Click:
62.     MsgBox Err.Description
63.     Resume Exit_btnDone_Click
64.  
65. End Sub
66.