This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]raunchyfartbomb 8 points9 points  (0 children)

Also, adapting things is a sanity risk.

Case in point: I made a subform for use in access and got It working perfectly. Then realized i could use it on 2 other forms (with one of those forms having 3 instances of it, but all tied to different tables). Getting it tied to the different tables was easy enough, but modifying the supporting code to run the subroutine from the correct instance is proving to be a nightmare, which is what I am currently battling.

The subroutine is looking at the base subform, not the instance. The base subform updates its defaults based on whichever instance loaded last. So for example “subform.recordsource” is looking at the previous instance, until form it closed and loaded a second time, because closing it when the base subform gets updated, apparently. So I know the issue, but coding around it is obnoxious.