Weird Access Problem
I'm having an odd situation come up within the access database that I am currently working on.
I have two seperate forms, and each form has a subform that accesses the same table. It is possible to input data for a given main record in either subform, and it should be possible to go back and forth between them.
What is odd is that in the second form/subform, I am having an issue when I attempt to access that data. If I have just entered a new record into the subform of the first form, then the second subform is incapable of working. It displays no data for any main record (not just the one that just received data). If I close down the form and open it again, everything works fine. I don't understand why the program is doing this. In the second form, I have a drop-down box which selects the ID of the main record, and when that is changed, it assigns the recordsource of the subform in code. That part seems to work fine, but it does not seem to change the recordsource property of the actual object.
Does this problem sound familiar to anybody and can it be solved?