Appending Records in subform tables

[Curtis Miller]

I have a form with several subforms on a tab control.
These are all in a 1 to 1 relationship with referential
integrity enforced. My problem occurs with adding new
records to the parent form... the subforms return errors
because there is no matching record in the table the
subforms a linked to.

I've tried setting the Cascade update in the
relationships, but this doesn't seem to work with record
additions (Access 2000).

I have append queries written that do the job on a batch
process, but I would like to make the updates real time...
any suggestions?

Curtis

 

[Josh Sharpe]

First you have to realize exactly when the records are created. Once you've
entered data into part a record and try to move out of it Access tries to
create the record. Since you have referential integrity inforced it isn't
allowing you to do that since there's no matching records.

You need to create some kind of unbound form with underlying queries in
order to create all of the records at the same time.

-Josh