Warm tip: This article is reproduced from serverfault.com, please click

ms access-使“ DoCmd.GoToRecord”功能在子窗体上工作

(ms access - Making "DoCmd.GoToRecord" function work on a subform)

发布于 2013-06-27 15:41:25

我一直在DoCmd.GoToRecord , , acNewRec成功使用该函数来在子表单(以表为源)中创建并移动到新记录。但是,当我尝试从父表单中执行相同操作时,这将不起作用。我尝试了不同的方法,包括:

Me.sbfrm_subform.Controls("ctrName").SetFocus
DoCmd.GoToRecord , , acNewRec

仅将焦点放在控件(ctrName)上,但无法添加并转到新记录,或者

DoCmd.GoToRecord acDataForm, Me.sbfrm_subform.Form.Name, acLast

它返回运行时错误2489,“对象'sbfrm_subform已打开nt”。

Questioner
Kambiz
Viewed
0
dennythecoder 2013-06-30 03:25:11

尝试将代码放入子窗体,然后从父级调用它:

子表格代码:

Sub GoToNewRecord()
     DoCmd.GoToRecord , , acNewRec
End Sub

家长表格代码:

Me.sbfrm_subform.GoToNewRecord