Lynn_AccessUser
Registered User.
- Local time
- Today, 05:53
- Joined
- Feb 4, 2003
- Messages
- 125
I have a form that uses the following code to handle 2 forms opened in an adp with the same record source.
see the following article:
http://support.microsoft.com/default.aspx?kbid=304181
Dim rs As ADODB.Recordset
Set rs = Me.Recordset.Clone
rs.Bookmark = Me.Bookmark
DoCmd.RunCommand acCmdRefresh
Me.Bookmark = rs.Bookmark
rs.Close
Set rs = Nothing
However, the form does not open now because there is a filter on the form.
Me.Filter = "ReqItemID = " & Forms!frmMain!subform!ReqItemID
Me.FilterOn = True
If I take the filter off the form opens (not to the correct record now) and can save changes to the data.
My question is how do I use a filter and a bookmark on the same form.
Thanks!!!
see the following article:
http://support.microsoft.com/default.aspx?kbid=304181
Dim rs As ADODB.Recordset
Set rs = Me.Recordset.Clone
rs.Bookmark = Me.Bookmark
DoCmd.RunCommand acCmdRefresh
Me.Bookmark = rs.Bookmark
rs.Close
Set rs = Nothing
However, the form does not open now because there is a filter on the form.
Me.Filter = "ReqItemID = " & Forms!frmMain!subform!ReqItemID
Me.FilterOn = True
If I take the filter off the form opens (not to the correct record now) and can save changes to the data.
My question is how do I use a filter and a bookmark on the same form.
Thanks!!!