更新时间:2023-01-29 09:49:38
mainform的属性如recordsource可以引用Me.recordsource引用
对于这种主形式上的子表单,您需要:Me!< subformname> .Form.recordsource
Nic; o)
嗨Nico,
我把它放在一起很麻烦。
>
这就是我所拥有的:展开 | 选择 | Wrap | 行号
嗯,请确保str包含一个有效的SQL Select字符串,并验证子表单的名称(参见属性窗口中的Other选项卡下面)是我之后使用的名称!
Nic; o )Dear all,
I have a question about ADO in the subform. I know how to use ADO to insert/update/select data into the sigin form, but wehn I try to do it in the form with subform((Datasheet). I don''t have any idea how to insert/update/select the recordset data into the subform(Datasheet), especially insert/update. Would someone can give me a idea or sample code to me? Appreciate your help.
OS: windows XP +SP2+ Access 2003+SP2
Database: MS SQL Server 2000+SP4The mainform''s properties like recordsource can be referenced with the "Me.recordsource"
For the subform on such a mainform you need: "Me!<subformname>.Form.recordsource"
Nic;o)
Hi Nico,
I''m having trouble putting this together.
This is what I''ve got:Expand|Select|Wrap|Line Numbers
Hmm, make sure that "str" contains a valid SQL Select string and also verify that the name of the subform (See under "Other" tab in properties window) is the name used after the Me!
Nic;o)