subform in subform

M

Maaike

Hi

I have a subform in a subform. Now I want to requery this second subform and move to the last record. I have tried this with the code below, but it doesn't work. The application moves to the last record of the main form. Does anyone know how I can achieve this?
 
M

Maaike

sorry, I forgot the 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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate main form from subform record 0
DLookup in Continuous form 0
subform based on external SQL won't requery 1
OpenForm and Navigate to Subform Record? 1
How to detect navigation 5
Referring to control in the active subform 0
VBA code returns no records hwenKey ID is added 14
main form/subform 1

Top