链接以在表单中打开记录 [英] Link to open a record in a Form
问题描述
主题:试图以名为fmappointment的形式打开记录。当点击看起来像超链接时文本框名为ContactID
我在我的数据库中做了很多这样的实例,但是在这种情况下我遇到了设置问题并且收到了错误insert perameter
注意:当我在弹出框中插入记录编号时,正确的记录确实显示
我有什么
文本框 - ContactID onDatessubform
主表格 - Frmcalendar
子表格 - Datessubform插入Frmcalendar
(1)我在contactId的文本框中创建了一个宏。我在Datessubform上看起来像一个超链接
(2)在点击中事件我已插入
[contactID] = [表格]![FrmCalendar]![Datessubform]![contactid]
注意:主要表格是日历" frmcalendar" 37个子表格datessubform这是一个连续的形式,名称为SF1至SF37
我尝试了很多很多变化,使这项工作没有运气。我能得到的最接近的是打开fmappointment中的第一条记录。不是我要求的那个。
我试图提供尽可能多的信息 - 如果需要更多信息,请询问。
我可以向专业人士咨询一些建议!
谢谢
加里
你的任务:
[contactID] = [表格]![FrmCalendar]![Datessubform]![contactid]
应该是:
[contactID] = [表格]![FrmCalendar]![Datessubform]!表格![contactid]
在主表格中激活时。
其他使用:
[contactID] =我![contactid]
只需检查:表单:请参阅表单和子表单属性和控件
(许多其他有用的信息那里:-)
Nic; o)
Nic; o)
感谢suggesstions。不幸的是,他们给出了与参数错误相同的结果。
我会研究你提供的链接。
谢谢
Gary
嗯,参数请求经常指向查询/表单的记录源中的错误字段名称。你检查了吗?
只是试着找到弹出窗口所指的字段并检查或该字段在表中。
Nic; o)
Subject: Trying to open up a record in a form called "fmappointment" when clicking on a "looks like hyperlink" text box called "ContactID"
I have made many instances of this in my database but in this case I am having a setup problem and getting the error "insert perameter"
NOTE: when I do insert the record number in the pop up box the correct record does show
What I have
Text Box - "ContactID" on "Datessubform"
Main Form -"Frmcalendar"
Subform - "Datessubform" inserted into "Frmcalendar"
(1) I have made a macro in the text box of "contactId" which I have made to look like a hyperlink on "Datessubform"
(2) In the "click" event I have inserted
[contactID]=[forms]![FrmCalendar]![Datessubform]![contactid]
NOTE: The main form is a calendar "frmcalendar" with 37 subforms "datessubform" that is a continous form with names "SF1 thru SF37"
I have tried many, many variations to make this work with no luck. The closest I can get is to open up the first record in the "fmappointment" not the one I am requesting.
I have tried to give as much information as possible - if more is needed please ask.
Time for me to ask the pros for some advice!
Thanks
Gary
Your assignment:
[contactID]=[forms]![FrmCalendar]![Datessubform]![contactid]
should be:
[contactID]=[forms]![FrmCalendar]![Datessubform]!Form![contactid]
when activated in the main form.
Else use:
[contactID]=Me![contactid]
Just check: Forms: Refer to Form and Subform properties and controls
(Many other useful info there :-)
Nic;o)
Nic;o)
Thanks for the suggesstions. unfortunately they gave me the same result with a paramenter error.
I will research the link you supplied.
thanks
Gary
Hmm, the "parameter request" often points to a wrong field name in a query / form''s record source. Did you check that ?
Just try to find the field the popup refers to and check or that field is in the table.
Nic;o)
这篇关于链接以在表单中打开记录的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!