Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Easy question: DoCmd.GoToRecord in subform

Status
Not open for further replies.

rafe

Technical User
Aug 18, 2000
194
US
Hi all,

I have a form with a continuous subform (A2K). I'm trying to goto a particular record in the subform from the main form. The statements I'm using are

Me.consEnter.SetFocus
DoCmd.GoToRecord acDataForm, Me.consEnter.Form.Name, acGoTo, i

the subform control name is "consEnter" & the subform's form name is "EnterConsultingDetail"

Me.consEnter.Form.Name returns "EnterConsultingDetail"

It's gotta be an easy fix but...

rafe [sig][/sig]
 
oops!

it was so easy I could figure out the answer...

DoCmd.GoToControl "consEnter"
DoCmd.GoToRecord , , acGoTo, i + 1
[sig][/sig]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top