Filter with Bookmark

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!!!
 

Users who are viewing this thread

Back
Top Bottom