Forum Discussion
Komei_Kato
Oct 11, 2023Copper Contributor
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 sam...
- Oct 12, 2023If 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
Oct 12, 2023Steel Contributor
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 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)
- Komei_KatoOct 17, 2023Copper ContributorHello!
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! - Komei_KatoOct 13, 2023Copper Contributor
Thank you for your reply.
I will make easy program and test if same result happen again or not.
Thank you.