更新事件后不起作用。 [英] After Update Event does not work.

问题描述

嗨专家，我是新手。我juts创建了一个带有子表单的表单，基于两个表格，具有1：多关系。


主表单来自tblStudents，子表单来自tble atte。

首先在主窗体上我从组合框中选择学生姓名，该学生的记录显示在窗体视图中的子窗体上。

1。*

Hi Experts, am new to access. I juts created a form with sub form based on two tables having 1: many relationship.

The main form is from tblStudents and subform is from tble attendance.

First on main form I choose student name from a combo box and records for that student is displayed on the subform in form view.

1.*

展开 | 选择 | Wrap | 行号

推荐答案

嗨

我认为你的问题是你需要附上你的结果单引号中的组合框。试着看NeoPa的Insight文章：
引用&双引号，何时何地使用它们


这是修改后的代码行：

Hi
I think your problem is that you need to enclose your result from the combobox in single quotes. Try looking at this Insight Article by NeoPa:
quotes & double quotes, where and when to use them

Here is the modified line of your code:

展开 | 选择 | Wrap | 行号

您好TheSmileyOne，感谢您的协助。

用代码替换我的代码会出现此错误消息。


运行时错误3464：标准表达式中的数据不匹配

Hi TheSmileyOne, Thanks for your assistance.
Replacing my code with your code gives this error message.

"Runtime Error 3464: Data mismatch in Criteria Expression"

展开 | 选择 | Wrap | 行号

任何想法都将不胜感激。无论如何，感谢链接。

Any ideas would be appreciated. Anyway thanks for the link.

这篇关于更新事件后不起作用。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！