Forms not linking

[teiben]

I have 2 tables Respondent & question, for a survey. THe relationship is one to many. I'm having users login on Form Login. After login the actual survey form opens and I hide the login form.
Problem is only the login information is writing to the table. I need the RespondentID to store a value in TblSurveyID.
Both forms are based on a query. I placed this on the form survey Before Update Event.

Me.ResponentID = Me.TblQuestion.ID, but I get an error message.

Any idea how to fix other than scrapping a form and using a subform(s)?

Help would be greatly appreciated.

 

[teiben]

Pat,

I tried both methods and I received both times "You tried to assign the null value to a variant that isn't a variant data type.

RespondentID is an autonumber and TblSurveyID is a number.