CODEWITHSUNDEEP
ms-accessvbams-access-2010
HB1963
HB1963

Reputation: 117

Issues with subforms in MS Access 2010

I'm having an issue with MS Access 2010 which drives me crazy. I do have a form with some subforms. The subforms are not linked to the main form, but their recordsource queries on some fields on the mainform. So far so good. If I change the values of the fields on the mainform the subforms are showing the correct records.

However when I reset the values on the mainform with some VBA code the issue begins.

Let's say one of my subforms has the following sourceobject: 

Me.[Subformulier].SourceObject = "Form A"

When I reset the mainform I use below code:

Me.[Subformulier].SourceObject = ""

..
execute some code

..

Me.[Subformulier].SourceObject = "Form A"

However my Subform isn't returning any records. The funny thing is however when I open the subform it is showing exactly the records I was looking for...

Can anyone help me with this?

Upvotes: 0

Views: 90

Answers (1)

HB1963
HB1963

Reputation: 117

OK, looks like I've found the answer on "http://www.access-programmers.co.uk/forums/showthread.php?t=55410". It appeared that my mainform was bound to a query were it shouldn't have been. Removing this bounded query did the trick. Thought I knew MS Access a bit, but appearantly there is still much to learn

Upvotes: 0

Related Questions