troubleshooting Question

MS Access--Psuedo Split Form Error

Avatar of giswest
giswest asked on
Microsoft Access
8 Comments1 Solution493 ViewsLast Modified:
I've implemented the code samples provided by Jeff Coachman (https://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24828935.html?sfQueryTermInfo=1+10+30+access+form+split+subform)  and Helen Feddema (https://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_26311529.html?sfQueryTermInfo=1+10+30+access+form+split+subform), which provide the code for establishing "split form" functionality between a main form and subform.  Everything works well, until certain types of filters are applied (Filter By Date, Filter By State/County, and Filter By Grantor of Grantee--See attached databases).  When one the specified filters is applied, and I then select a record in the subform, I either recieve a Run-time error '2473' error (Pseudo_Split_Form_boaq2000) or Error No: -2147417848; Description: Method 'FindFirst' of object 'Recordset2' failed Error.

Based on the debug results, it appears that the error related Helen's code is linked to the Me.Parent.Bookmark = Me.Parent.RecordsetClone.Bookmark portion of the code.  However, I'm not sure which portion of Jeff's code is producing the Run-time error.

Any help on these issues is appreciated.
Psuedo-Split-Forms.zip
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 8 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros