SOLVED

When DataEntry add row,combo box pick up unintended value.

Copper Contributor

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.

スクリーンショット 2023-10-12 080458.png

 

 

3 Replies
best response confirmed by Komei_Kato (Copper Contributor)
Solution
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)

@Tom_van_Stiphout 

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!
1 best response

Accepted Solutions
best response confirmed by Komei_Kato (Copper Contributor)
Solution
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)

View solution in original post