subform in subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have a subform in a subform. Now I want the second subform to requery and move to the last record. I have tried this with the following code

Me![subFrm_AnswerData].Form![subFrm_Answers].Requer
Me![subFrm_AnswerData].Form![subFrm_Answers].SetFocu
Me![subFrm_AnswerData].Form![subFrm_Answers].Form!txtSubnumber.SetFocu
DoCmd.RunCommand (acCmdRecordsGoToLast

but it doesn't work. Does anyone know what I am doing wrong and how to solve this?
 
Solved! by putting the focus first on the first subform and then on the second subform it works!
 
Back
Top