duplicating child record into another parent? need help

[Nate1749]

My setup is this

tblMonth
MonthID ------------one-many with MonthID in tblTopic. Referential Integrity Enforced
MonthAndYear

tblTopic
TopicID ------------one-many with TopicID in tblHighlights. Referential Integrity Enforced
TopicName
MonthID

tblHighlights
Highlight
TopicID
OwnerID
SummaryPointID
GeographID

tblSummaryPoint
SummaryPointID -------------one-many with SummaryPointID in tblHighlights
SummaryPoint

tblGeography
GeographyID ------------one-many with GeographyID in tblHighlights
Geography

tblOwner
OwnerID ------------one-many with OwnerID in tblHighlights
Name
Department



This database tracks all the activity reports from the various departments. The department heads go in each month and enter the activity for their department. The problem they are running into is that every month the activity is fairly similar to last month and they would simply like to copy/paste in into a new record for the current month.

Currently on the main form they select the month by a combo box... Then I have a subform where they either select or add a topic. Then in another subform there are the highlights for the topic. They enter in the highlights (activity) in there; there are also 3 other combo boxes that are required in which they must choose their department, geography, and what type of highlight it is (activity or summary)....

So the settup is
Month --> Topic --> Highlight

Is there a way to copy (duplicate?) a record (specifically the 'highlight' record) from one month into another? I can use the command button and set it to duplicate record, but that makes the record dupliate in the current context; I would like to be filed (choose somehow) to go under the next month...

Thanks,

-Nate

 

[hassanmfsa]

Hi,

Try this,

1. Create a textbox where you want the value to be duplicated.

2. Go to the properies of the textbox. Then: Press Data tab.

3. Notice the "Control Source". Press the side button "..."
4. Choose the Forms category.. Loaded Forms....Then the form that is open and having the value you need.
If you don't need it to be open try just All Forms.

5. Specify the field aimed from the loaded form or the intended form.

I hope this helps or enables you to remember an idea.