After Update & creating new record in a subform

  • Thread starter Thread starter Stephanie
  • Start date Start date
S

Stephanie

This seems so simple, yet I can't figure it out! I have a
subform that lists tasks related to a project on the main
form. I have a checkbox for the user to check when the
task is complete and then I want to start a new record
tied to the ProjectID on the current form to display so
that the user is prompted to set up the next task. I got
the form to appear when the box is checked, but how do I
get the ProjectID to copy over? The name of the subform
is TaskLog.

Thanks,
Stephanie
 
Hi Stephanie,

One solution is to let Access do it for you.
Assuming Tables Projects and Tasks linked by Project Id (1 to many):

Main Form record source is Projects
Sub form record source is Tasks

Set the link master/child fields to be Project Id. Any new record added to
the subform automatically inherits the selected Project Id.


hth,
Andy
 
Hi Stephanie,

Andy gave good suggestion; I just would like to add some resource that you
may be interested in:

283878
ACC2002: Database Normalization Basics
http://support.microsoft.com/default.aspx?scid=KB;EN-US;283878

283698
ACC2002: "Understanding Relational Database Design" Document Ava
http://support.microsoft.com/default.aspx?scid=KB;EN-US;283698

289533
ACC2002: Where to Find Information About Designing DB in Access
http://support.microsoft.com/default.aspx?scid=KB;EN-US;289533



Sincerely,

Alick Ye, MCSD
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.


--------------------
| Content-Class: urn:content-classes:message
| From: "Stephanie" <[email protected]>
| X-Tomcat-NG: microsoft.public.access.formscoding
|
| This seems so simple, yet I can't figure it out! I have a
| subform that lists tasks related to a project on the main
| form. I have a checkbox for the user to check when the
| task is complete and then I want to start a new record
| tied to the ProjectID on the current form to display so
| that the user is prompted to set up the next task. I got
| the form to appear when the box is checked, but how do I
| get the ProjectID to copy over? The name of the subform
| is TaskLog.
|
| Thanks,
| Stephanie
|
 
Back
Top