尝试使用命令按钮或报告事件更新组合框 [英] Trying to update a combo box using a command button or report event

问题描述

我有一个包含子格式的表单，其中包含我要更新的组合框。我在主窗体的标题中有一个命令按钮，用于在打印预览模式下启动报表。我想在生成报告时将组合框从新建更新为确认。我在按钮on_click事件和报告on_close事件中尝试了以下代码（安全性设置为信任数据库）

I have a form with a subform containing the combo box I want to update. I have a command button in the header of the main form that launches a report in print preview mode. I want to update the combo box from ''New'' to ''Confirmed'' when the report is generated. I have tried the following code in both the buttons on_click event and in the reports on_close event (security is set to trust the db)

展开 | 选择 | 换行 | 行号

推荐答案

你的语法略有偏差。

Your syntax is slightly off.

展开 | 选择 | Wrap | 行号

您是否可以与我们分享这个ComboBox如何设置Richard？


我们真的没有足够的信息来确定你的问题。 .RowSource，.ColumnCount，.ColumnWidths& .BoundColumn属性最有用。

Can you perhaps share with us how this ComboBox is set up Richard?

We don''t really have enough info to determine what your problem may be. .RowSource, .ColumnCount, .ColumnWidths & .BoundColumn properties would be most helpful to start with.

@DonRayner


I对不起唐。我觉得你可能会在这里弄错。


查看参考子表单上的项目。 .Form属性相对于SubForm控件。

@DonRayner
I''m sorry Don. I feel you may be mistaken here.

Check out Referring to Items on a Sub-Form. The .Form property is relative to the SubForm control.

这篇关于尝试使用命令按钮或报告事件更新组合框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！