Carry specific data to new record

[Bagger]

I have 3 forms. I use form 1(Song Book Title) "setvalue" to insert the "CallNumber" value into a form2(Song Occurrence)
and a "setvalue" to insert "IdNum" value into a form3(Song). this procedure works works great the firtime thru. Now I need to create additional records in form2 , but want to keep the last value that form1 posted for me in the new record.

as an example; form1: Song Book Title : song from the 80's
CallNumber: 784.8 jan 98

form2: CallNumber: 784.8 jan 98 (from form1)
IdNum: 50123

form3: IdNum 50123 (from form2)
Song Title: Blue Moon

Next record: form2: CallNumber: 784.8 jan 98
new IdNum IdNum: 50124

form3: IdNum: 50124 (from form2)
Song Title: Rainy Day


Thanks in advance

 

[jfischer]

Try the following idea to carry over the CallNumber on Form2.

In the "AfterUpdate" event for the CallNumber control on Form2, add the following code:

Const cQuotes = """"
Me!CallNumber.DefaultValue = cQuotes & Me!CallNumber.Value & cQuotes