表格编辑&删除 [英] Form For Edit & Delete

问题描述

我有表格可供编辑和删除

我在表格内编辑或删除工作

我有before_update触发器

I have form for edit and delete
within me form edit or delete job
I have before_update trigger

展开 | 选择 | Wrap | 行号

推荐答案

hi，

我需要一个解决此问题的方法

谢谢

I need a solution for this problem
thank you

删除 DoCmd.ShowAllRecords 后会发生什么？我之前从未使用过这个，但基于快速回顾，看起来你不应该需要它，除非先前有一个过滤器应用于表格''的记录源。


Pat

What happens when you remove DoCmd.ShowAllRecords? I have never used this before, but based on a quick review it seems like you shouldn''t need it unless there was a filter previously applied to the form''s recordsource.

Pat

@ zepphead80


感谢您的回复

当我删除DoCmd.ShowAllRecords我收到错误下一行代码

DoCmd.GoToControl（" job_ID"）

DoCmd.FindRecord我！cboJob_ID

我认为我使用的代码没有为编辑表单的目的而工作完美

所以我会使用创建谓词，使用beforeupdate触发器来防止控件为空

请给我任何建议

谢谢，我非常感谢您的帮助

@zepphead80
thank you for your reply
when I remove DoCmd.ShowAllRecords I get error for next lines of code
DoCmd.GoToControl ("job_ID")
DoCmd.FindRecord Me!cboJob_ID
I think the code I use doesn''t work perfectly for the purpose of edit form
so I would use create predicate , with beforeupdate trigger to prevent controls to be null
please provide me any suggestions
thank you I really appreciate your help

这篇关于表格编辑&删除的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！