Adding related record automatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form which fills in the many side of a one-to-many relationship. In
the beforeupdate event procedure I have a routine which checks to see if
there is a related record in the one side of the join, and if not adds it.
This routine works if the record source for my form is based on a single
table. As soon as I add a second joined table to the recordsource I get the
"cannot find a related record...." error when I try to move to the new
record. I am using Access 2000

Thanks,


Eric Sambell
 
You can not create a child record (the many side) before creating the parent
the one side)! However, you can set your form to first create the parent
record before it adds the child information to the many side table.
2005 >>>
I have a form which fills in the many side of a one-to-many relationship. In

the beforeupdate event procedure I have a routine which checks to see if
there is a related record in the one side of the join, and if not adds it.
This routine works if the record source for my form is based on a single
table. As soon as I add a second joined table to the recordsource I get the

"cannot find a related record...." error when I try to move to the new
record. I am using Access 2000

Thanks,


Eric Sambell
 
Back
Top