Hi,

I am entering data into 2 tables using the same form, the PK of the first table cannot be entered in the second table unless it exists on the first table. The problem is that the first table does not update the data entered before the second table looks for the PK in the first table.

I wonder if it's possible to make the form update its source table while the form is still opened and no records have been cycled?

Any suggestions will be very much appreciated.
B:)

Why aren't you doing this with a main form and a subform. I think that that would solve your problem.