Updating a related table

[Gerry Abbott]

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

[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" <pl****@ask.ie> wrote in message
news:1a*******************@news.indigo.ie...

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

[Dave M]

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" <pl****@ask.ie> wrote in message
news:1a*******************@news.indigo.ie...

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

[Gerry Abbott]

Hit the nail right on the head
Thanks Dave,
"Dave M" <NO************@DROPTHISisland.net> wrote in message
news:Y9nrd.400583$nl.94527@pd7tw3no...

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" <pl****@ask.ie> wrote in message
news:1a*******************@news.indigo.ie...

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