Search results

Thanks for the replies. It took me some time to work out the solution: Once the pointer has moved... 1) Close FormA 2) SetFocus to the record number on FormC that the pointer moved to... Syntax: Forms!FormB!FormC.Form.Record Number 3) Store the record number in a new variable (Same syntax as...

Dim rs As DAO.Recordset Set rs = [Forms]![FormB]![FormC].[Form].RecordsetClone rs.BookMark = [Forms]![FormB]![FormC].[Form].BookMark rs.MoveNext [Forms]![FormB]![FormC].[Form].BookMark = rs.BookMark rs.Close Set rs = Nothing I used the above code and it works perfectly! I have a "Next...

I found this post and this code worked perfectly for me! Next Question: In my database, I am in FormA, click on the button I created, and the focus moves to either the next or previous record on FormC, which is a Subform of FormB and is a Datasheet. What I now want to do is load the data from...