使用表单中的文本框在表中输入数据 [英] Entering data in a table using a text box in a form

问题描述

我试图创建一个表单，使用户可以使用文本框更改表中的数据。我有有限的VBA和SQL的知识，但我试图去使用SQL。

I am trying to create a form which enables a user to change the data within a table using a text box. I have limited knowledge of VBA and SQL but I tried to have a go using SQL.

UPDATE WIP SET WIP.[Current Stock] = [WIP]![Current Stock]
WHERE (((WIP.[Part Code])=[Forms]![Stock In]!Text27));

这是我想出的，但它似乎没有工作。

This is what I came up with but it doesnt seem to work. Any help would be greatly appreciated.

推荐答案

尝试：

UPDATE WIP SET WIP.[Current Stock] = [Forms]![Stock In]![Current Stock] 
WHERE WIP.[Part Code]=[Forms]![Stock In]![Text27]

或

UPDATE WIP SET WIP.[Current Stock] =  
       WIP.[Current Stock]+[Forms]![Stock In]![Current Stock] 
WHERE WIP.[Part Code]=[Forms]![Stock In]![Text27]

---

重新评论

---

Re comments

猜猜，我会想象：

UPDATE WIP SET WIP.[Current Stock] 
       = [WIP]![Current Stock] + [Forms]![Stock In]![Text27]
WHERE WIP.[Part Code]=[Forms]![Stock In]![Combo19]

或

UPDATE WIP SET WIP.[Current Stock] = [Forms]![Stock In]![Text27]
WHERE WIP.[Part Code]=[Forms]![Stock In]![Combo19]

这篇关于使用表单中的文本框在表中输入数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！