After Update & creating new record in a subform

[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

 

[Andy]

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

 

[Alick [MSFT]]

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
|