Forum Discussion
When DataEntry add row,combo box pick up unintended value.
Hello!
On Access2021 ,using "DataEntry" I made screen like this shot.
At first there is one row(Every columns are blank).Then I skipped 4columns and enter "2" in the last column.(AnyValue occur same problem)
Then second row comes and first combo-box get unintended value automatically.
"0004" is not in the rowsource-list. I want the first column to be blank.
How to avoid this problem? Help me.
In addition,I told "Then I skipped 4columns",but I enter 2nd or 3rd field occurs same problem.
- If you do the same data entry in the underlying table or query, do you get the same result?
If not, then there must be something in your form that makes this happen. Could be:
* a default value
* VBA code
* macro code
* data macro code (but then it would happen in table data entry too)
- If you do the same data entry in the underlying table or query, do you get the same result?
If not, then there must be something in your form that makes this happen. Could be:
* a default value
* VBA code
* macro code
* data macro code (but then it would happen in table data entry too)Thank you for your reply.
I will make easy program and test if same result happen again or not.
Thank you.
- Hello!
According to your advice, I made easy program and test. But same problem did not happen.
And I found out the cause of this problem. I had made hidden textbox link to same data and that had "004". I don't know why the hidden column has "004", but after erasing the textbox, it works fine.
Thank you!
