我的级联组合代码有什么问题 [英] Whats wrong with my Cascading Combo Code

问题描述

大家好


我在访问时是新手。我的公司要求所有数据库都在公司SQL后端运行，因此我有一个连接到服务器的Access项目。


我有两个表，表1称为tblProjectDetails，表2称为tblLearners

tblProjectDetails中的字段是

Hi all

I am a newbie when it comes to access. My company requires that all Databases run on the company SQL back-end as a result i have a Access project that connects to the server.

I have two tables, table 1 called tblProjectDetails, table 2 called tblLearners
The fields in tblProjectDetails are

展开 | 选择 | Wrap | 行号

推荐答案

你好。看来您将子窗体上的控件称为WHERE子句的一部分。此语法与您编写的语法略有不同，因为子表单在主窗体上时会被视为控件。要访问子表单中的控件，您需要引用其表单属性：

Hi. It would appear that you are referring to a control on a subform as part of your WHERE clause. The syntax for this is slightly different to what you have written, as the subform is treated as a control when it is on the main form. To access a control within the subform you need to refer to its form property:

展开 | 选择 | Wrap | 行号

展开 | 选择 | Wrap | 行号

谢谢你们/>

看来我现在仍然卡住了''我要么得到一个空白的组合框或一条错误信息，其中包含

Thanks guys

It seems now I''m still stuck ''cos i either get a blank combo box or an error message which reads

此表单或报告中指定的记录源''SELECT * from tblLearners，其中ProjectNo = 39''不存在

The record source ''SELECT * from tblLearners where ProjectNo = 39'' specified on this form or report does not exist

任何想法？


再次感谢

Any ideas?

Thanks again

这篇关于我的级联组合代码有什么问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！