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?


Mat

If ur subform and main form have a one-to-many relationship u cant enter new
data in the many side of ur form without entering data in the one side (main form).That what suggest me ur post but an elegant solution i dont have.
Regards P.

Matt,
In my understanding you are working on three tables.
The first two tables are for the main forms (tbl1 & tbl2).
And the last table is for the subform (tbla).
I do not think there is a program problem.
Not because you updated a subform1 (tbla) with
mainform1 (tbl1)
will update it in mainform2 (tbl2)
with the same recordsource as in subform2 (tbla).

If you want to update fields in a subform (tbla) that automatically
update fields on related main forms/tables you will be better
of with AfterUpdate function VBA code.
I hope this helps.
John