Defaulting fields

[coffeecraze]

I have a complex circle of information.
Here is what I need:

Create new record table1 from form "initial"
Create new record table2 from form "progress" with fields 1,2,3
defaulted from last "initial" record
Create new record table3 from form "plan" with same fields defaulted
from last record from "progress"
Create new record "progress" defaulted fields from "plan"
Create new record "progress" defaulted fields from latest fields from
either "progress" or "plan"

Basically I need fields 1,2,3 to default the latest entry into 3
different forms when they are created and using the most current/
updated entry.

I am making this happen with subforms, but my problem is I change the
original context.

So I need the first "initial" to stay original even if another is
made. first, second, third ect "progress" all stay original when
another is created and so forth.

its a bit confusing any help would be great. Thank you in advance.

 

[Jeff Boyce]

Access is a relational database. It all starts with the data.

I don't understand your data structure or relationships well-enough to offer
suggestions.

Please provide more information about them...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.