Strange Behavior with a Form

  • Thread starter Thread starter Dwayne Conyers
  • Start date Start date
D

Dwayne Conyers

We have a form that reads a numeric value from its table ("Reports"). This
value is stored in a hidden text field.

The number corresponds to a key in another table ("Values"), so we created a
dropdown control populated with the items from that table with the value
selected stored in the hidden text field.

This worked perfectly for a while (and has worked with other forms) but
lately upon entry to the form we receive an error message:

"The text you entered isn't an item in the list.
Select an item from the list, or enter text that matches one of the listed
items"

Additionally, the data in the "Values" table is being overwritten with the
text that populates the drop-down being changed to the numeric value.

We deleted and recreated the dropdown controls and the behavior continues.
 
On your other post it appears to be a problem with the bound field.
Remeber, access stored the bound field not the one that shows in the list.
If your bound column is 1, even if you have the width to 0, it will still
use that column.

For this post, can you post the code you are using to update the source for
the drop down. This one always seems like something strange with the way
the reference to the hidden box. Seeing the code will help.

Kelvin
 
Back
Top