Hi all,
Im using the after update event of a field from a bound form to add records
using the recordset object, to a related table. However i'm getting the 3201
error, telling me I must have a related record in the parent table. But i've
just put it in, since the 'afterupdate' wont fire until i have ? It works
fine when i'm changing the record in the parent table, since im not changing
the primary key, but happens when i'm adding a new record.

Any explaination, or advice most welcome

Gerry Abbott

Apologies for not testing this further,

It is not working with the update, and uses the 'non-updated' data to update
the related table, not the updated!


"Gerry Abbott" <please (AT) ask (DOT) ie> wrote

It sounds like you need to save the parent record before adding the new
child ones. The value of the field may be getting updated, but this does not
save the record. If you precede your record-adding code with

DoCmd.RunCommand acCmdSaveRecord

that should help.

"Gerry Abbott" <please (AT) ask (DOT) ie> wrote

Hit the nail right on the head
Thanks Dave,


"Dave M" <NOSPAMdmacmurc (AT) DROPTHISisland (DOT) net> wrote