Tab/Move into subform

[Guest_imported]

How can I move into a subform using the tab order facility?

Also how can I move into a subform using the setfocus. I have used setfocus to move from search field to the first field needing updating but can't get it to go into my subform. Why?

 

[DougP]

you have to set focus to the subform first

here is some code I use all the time, you may not need all of it...

'add record to sub form
Me![Yoursubform].SetFocus
DoCmd.GoToRecord , , acNewRec

'assign a value to a field in that sub form
Me![Yoursubform].Form![DrawingNumber] = ActiveXCtl1.FileName

'save the record
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

' Requery the sub form
Me![Yoursubform].Requery



DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive