表格编辑&删除
问题描述：
我有表格可供编辑和删除
我在表格内编辑或删除工作
我有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