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

查看:67
本文介绍了表格编辑&删除的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述



我有表格可供编辑和删除

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

我有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屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆