在未绑定控件中显示值 [英] Displaying Value in Unbound Control

问题描述

所以你对我正在做的事情有一些背景知识，我正在为我的学校建立一个学位审计，这需要通过入学年级/学期（存储在DegReq中）建立学位要求并将其分配给学生（ StdDegReq）。这有点长，但我想提供我认为必要的尽可能多的信息。


我的问题有3个表格：


MatricYT：MatricId（PK），MatricYear，MatricTerm

DegReq：DegReqId（PK），MatricId（FK）（degreqs由matric年/学期建立）

StdDegReq：StdDegReqId（PK），PersonId（FK），DegReqID（FK）


我有一个表格，其记录来源是StdDegReq，允许用户为学生分配学位要求计划。该表单有两个组合框：cboMatricId（未绑定）和cboDegReqId（绑定到DegReqId）。


cboMatricId'的rowsource拉取MatricYT中的所有可用值，cboDegReqId'的rowsource拉取所有DegReq中的可用值。因为我希望cboDegReqId中的值由cboMatricId中选择的MatricId确定，所以我将以下代码放在cboDegReqId的GotFocus事件中：

So you have some background to what I''m doing, I''m building a degree audit for my school which requires the building of degree requirements by matriculation year/term (stored in DegReq) and assigning them to students (StdDegReq). This is a little long but I wanted to provide as much information that I thought necessary.

There are 3 tables related to my problem:

MatricYT: MatricId (PK), MatricYear, MatricTerm
DegReq: DegReqId (PK), MatricId (FK) (degreqs are built by matric year/term)
StdDegReq: StdDegReqId (PK), PersonId (FK), DegReqID (FK)

I have a form whose record source is StdDegReq which allows a user to assign a degree requirement plan to a student. The form has two combo boxes: cboMatricId (unbound) and cboDegReqId (bound to DegReqId).

cboMatricId''s rowsource pulls all available values in MatricYT and cboDegReqId''s rowsource pulls all available values in DegReq. Because I want the values in cboDegReqId to be determined by the MatricId selected in cboMatricId I''ve put the following code in cboDegReqId''s GotFocus event:

展开 | 选择 | Wrap | 行号

推荐答案

我可以告诉你的问题是如何形成的，我正在处理一个聪明，称职的人，所以我将从这个链接开始在表单上过滤示例）。


如果这样做的话不能帮助你解决问题，或者如果你发现它错过了重点，请回复，我们可以更详细地进展。

I can tell from how your question is formulated that I''m dealing with an intelligent, competent person, so I''ll start with this link Example Filtering on a Form).

If this doesn''t help you to your solution, or if you find it misses the point, post back and we can progress in more detail.

我下载了示例数据库并对其进行了审核但发现了这对我没有帮助（除非我错过了什么）。


按照我上面写的，这里可能是一种更简单的方式来解释我的内容想做：


这是我的绑定组合框cboDegReqId的行源：

I downloaded the sample db and reviewed it but found that it doesn''t help me (unless there''s something that I missed).

Taking what I wrote above, here''s perhaps a simpler way of explaining what I want to do:

This is the rowsource of my bound combobox cboDegReqId:

展开 | < span class =codeLinkonclick =selectAll（this）;>选择 | Wrap | 行号

NeoPa

罪我看到你是管理员发表回复之间的区别是什么？在快速回复和回复之上它会带你到每个帖子底部的QUick Reply？我是新来的，不知道何时使用哪一个。

NeoPa
Since I see you are an administrator what is the difference between "Post Reply" above the Quick Reply and the "reply" which takes you to the QUick Reply at the bottom of every post? I''m new here and am not sure when to use which one.

这篇关于在未绑定控件中显示值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！