Propagate a form number

[mbaycura]

I have a form called "Idea Entry" and one called "NPI entry" in a database
for tracking idea progression through product development. when someone logs
an idea, the "Idea Entry" has a field called ID that is an autonumber field
to identify the record. Later, the idea will become an NPI and at that stage
I want users to click a button on the record in the "Idea Entry" form that
will open the "NPI Entry" form go to "New" and give that New NPI form the
same number as the previously automatically created Idea Number from "Idea
entry". In the end I will have two records, one of the original idea and one
of the NPI questions with the same number as the idea.

I've tried using a SetValue macro without success and I've also tried
setting a tempvar in the Idea Entry, then open the "NPI Entry" form, and set
the ID field in the NPI Entry directly or the control to be the temp value,
but that is not working either. I've set dummy textboxs to verify what the
tempvar is and it is the correct value, but I can't get the ID field/NPI
Number control value to become the Tempvar value.
any suggestions?