subform in subform

M

Maaike

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?
 
M

Maaike

Solved! by putting the focus first on the first subform and then on the second subform it works!
 

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

DLookup in Continuous form 0
Populate main form from subform record 0
subform based on external SQL won't requery 1
how to goto last record, add new record 19
VBA code returns no records hwenKey ID is added 14
OpenForm and Navigate to Subform Record? 1
Subforms within a Tab control 4
subform control reference fails 4

Top