main form with linked form question

[Aimee]

I have a main form (frmAnswers) that has a command button
link that opens another form (frmNotes). When the user
clicks the Notes button in frmAnswers, the frmNotes form
opens to allow the user to enter notes about the selected
answers in the main form. The two forms are connected by
RespondentID by [frmNotes][RespondentID]=[frmAnswers]!
[RespondentID] in the RespondentID text box of frmNotes.

My problem is that when I check to make sure the
information is in the table for frmNotes, the RespondentID
table column is blank. How can I make it so the
RespondentID column in the table contains information?

Any help would be appreciated.

Thank you, Aimee

 

[david]

In the On Load event for frmNotes, type the following

Me.RespondentID=Forms!frmAnswers!RespondentID

sometimes it helps to force it into place with

Me.Recalc

afterwards so that the data is not in the limbo world of a
new record. If you input data in a New Record on a form,
it is in an ethereal world until that record transforms
into the Last Record. Until that happens, the record will
not appear in the underlying table.