Copy to new, minus two fields

A

Angela

I'm hoping this is an easy enough question for those with more experience
than myself. I am trying to copy all values from a form which has many
subforms on it to a new form...this works perfectly with the built in button
control "duplicate record." However, I really need two of the fields to be
reset to blank, so they will update those two fields for sure. Specifically
it's a project update form, and I want all of their updates from the previous
week to show up (so they can change only what they need to) but the date
begin and date end should ideally go blank, so they can update those fields.
Is this something I can reasonably accomplish?

Thanks so much in advance!
Angela
 
U

unhinged

Angela,

My apologies for the briefness of this answer; I suggest you
investigate the APPEND query using Access Help and set up a button to
execute such a query.

Daniel.
 
A

Angela

Thanks, Daniel. That might work ok except for the fact that my form contains
5 subforms, all of which are their own separate tables. I don't see how I
can do an append query and update so many different tables, or am I missing
something?

To summarize what I'm doing, I have a form that contains weekly updates.
The subforms contain tables that all have a 1 to many relationship; in other
words, for one weekly update, I can update that I am currently working on 5
project names (its own table, selected from the 'projects' table), I have 5
updates that I did last week (stored in a table of its own), I plan on doing
5 things next week (again, it's own table) and so forth. The form and
subforms are tying together correctly and all the fields copy using the
shortcut of the system's 'duplicate record' code, but I'd rather the date
field be blank. Commonly there are tasks that span several weeks so this is
a shortcut for them to copy last week's report and just go from there.

I hope this makes sense. I can send any code if it's helpful. I know
enough SQL and Access to get me so far, but when I try to make it customized
like this, I sometimes get stuck.

Thanks again!
 
U

unhinged

Angela,

When you duplicate the record, you end up with the foreign keys that
you have tied to your "many" tables being brought into the new record
also - so if you want to keep that same list of items in your "last
week" and "next week" lists, using an APPEND statement to duplicate
all but your required two of the fields to the new record will also
work just fine.

Perhaps some more explanation is in order - what (date?) fields are
you requiring to be updated by the user?
 
Top