为什么我的查找值被复制到我的表单中的其他记录？ [英] Why Is my Lookup Value Being Copied to Other Records in My Form?
问题描述
我正在使用Access 2003，并不熟悉Access或其术语。我对VB一点都不熟悉。
我从查询中创建了一个表单，一切都运行正常。
之一表单上的字段基于位置查找表。我已经指定了一个默认值1（转换为NOT CHOSEN），这就是我进入表单时所有内容的显示方式。我在原始表和表单本身中分配了默认值。
然而，当我在表单中并将第一个记录更改为不同的值时（例如，2表示翻译）到QUEENS），然后当我翻页时，所有其他记录现在显示为QUEENS。
如何阻止所选的查找值通过我的数据库的其余部分传播很好的谢谢，
Kristin Graves
am using Access 2003, and am not very familiar with Access or its terminology. I am not at all familiar with VB.
I created a form from a query, and everything is generally working fine.
One of the fields on the form is based on a lookup table for location. I have assigned a default value of 1 (which translates to NOT CHOSEN), and that''s how everything shows up when I go into the form. I assigned the default both in the originating table and in the form itself.
However, when I am in the form and change the first record to a different value (say, 2 which translates to QUEENS), then all of the other records now show up as QUEENS when I page through them.
How do I stop the chosen lookup value from being propogated through the rest of my database?
Many thanks,
Kristin Graves
推荐答案
听起来就像这个领域一样未绑定到表/查询中的字段。如果你看一下你的组合框的属性是什么：
Controlsource
RowSource
Sounds to me like the field is not bound to a field in your table/query. If you look at the properties of your combobox what is the:
Controlsource
RowSource
control source = location（其中一个查询中的字段是我的来源
表单）
row / source type = table / query
row / source = locations（查找表的名称）
control source = location (one of the fields in the query that is my source
for the form)
row/source type = table/query
row/source = locations (name of lookup table)
查询的SQL语句是什么？如果右键单击查询设计窗口的灰色区域，则可以选择SQL视图。只需复制粘贴那里的SQL语句。
What is the SQL statement of your query? If you right click in the grey area of query design window, you can select SQL view. Just copy paste that SQL statement here.
这篇关于为什么我的查找值被复制到我的表单中的其他记录？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
