Field will not change

  • Thread starter Thread starter abundeza
  • Start date Start date
A

abundeza

I have a table called LandPattern which contains a text
field named DecalName which is the primary key.

DecalName is a foreign key in another table called
ComponentInfo. I made this field a Combo Box which lists
the records in DecalName so that we could select from the
records in the LandPattern table.

My problem is that I have a record with DecalName of "TO-
3_HS" and I need to add a record with DecalName of "TO-
3_HSA". I mistyped "TO-3_HAS" into the new record the
first time I entered it. So I try to go back and edit
it. However, as soon as I try to correct the last two
letters from "AS" from "SA" and hit Enter, Space, arrow
key, or move the mouse to another record, the name changes
back to "TO-3_HAS"

I've tried a few things out:

-deleting the entire record and reentering the information
as a new record.
-Breaking the tie from the ComponentInfo table to the
LandPattern table before editing the field.
-Editing the field from two different forms: 1. Editing
data in ComponentInfo table 2. Editing data in LandPattern
table.
-Duplicating the error (I can't duplicate it)

None of these have given me a solution to the problem and
I've searched in different categories on these newsgroups
without any luck.

Anybody out there know whats going on?

Thanks,

Angel
 
I have a table called LandPattern which contains a text
field named DecalName which is the primary key.

DecalName is a foreign key in another table called
ComponentInfo. I made this field a Combo Box which lists
the records in DecalName so that we could select from the
records in the LandPattern table.
Click to expand...

You're yet another victim of Microsoft's misdesigned Lookup Wizard.

Open this table in design view and change the Lookup property of this
field from Combo Box to textbox. You will see that what's actually
STORED in the table is not what you see, but a pointer!

Make sure that you have the right values in your LandPattern table;
and I'd suggest using a Form (with a combo box, natch) rather than a
table datasheet for editing it.
 
Back
Top