Moving a subform with a command button

[ind]

I want to move to a new record on a subform using a command button on the main, rather than using the scroll bar or the navigation buttons.<br>How do I do this?

 

[gol4]

use a macro. See goto control and goto record.

 

[Guest_imported]

What version of Access are you using? You should be able to just choose the button tool from the toolbar, then drop it on the form, and choose The &quot;Go to next Record&quot; from the wizard. <p>John Vogel<br><a href=mailto:johnvogel@homepage.com>johnvogel@homepage.com</a><br><a href=

http://i.winfire.com/s/isapiEng.dll/wf.exe?cmd=rl&452,20004878&wf.exe>Get

FreeDSL Service</a><br>[To a get FREE DSL Modem WITH FREE DSL Unlimited Internet Connection click the above link ]

 

[DougP]

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'add record to sub form<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Me![Drawings subform].SetFocus<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DoCmd.GoToRecord , , acNewRec<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'assign a value to a field in that sub form<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Me![Drawings subform].Form![DrawingNumber] = ActiveXCtl1.FileName<br><br> &nbsp;&nbsp;&nbsp;&nbsp;'save the record<br>&nbsp;&nbsp;&nbsp;&nbsp;DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70<br><br> &nbsp;&nbsp;&nbsp;' Requery the sub form<br>&nbsp;&nbsp;&nbsp;&nbsp; Me![Drawings subform].Requery<br><br>