Dropdown selection that disappears
Solved
-
Hello,
As part of my internship, I need to create data entry forms in different tables, and everything works from there. A problem arises when I select an item from a dropdown list. Once selected, the choice disappears (only in the display) but when I add the new entry, the choice made in the dropdown list is indeed present in the table.
The problem is just the disappearance upon selection of the chosen item. Do you have a way to keep the selection displayed in the list?
Thank you, I'm linking: https://cjoint.com/c/HFwnZXc0wsw; my Access file, it concerns the form for adding compatibility (F_Ajout_Compatibilite), the field "Product Version" that is problematic.
As part of my internship, I need to create data entry forms in different tables, and everything works from there. A problem arises when I select an item from a dropdown list. Once selected, the choice disappears (only in the display) but when I add the new entry, the choice made in the dropdown list is indeed present in the table.
The problem is just the disappearance upon selection of the chosen item. Do you have a way to keep the selection displayed in the list?
Thank you, I'm linking: https://cjoint.com/c/HFwnZXc0wsw; my Access file, it concerns the form for adding compatibility (F_Ajout_Compatibilite), the field "Product Version" that is problematic.
1 answer
-
ContributorHello, it's line 3 in the following code that is responsible for this.
Private Sub VersionProduit_AfterUpdate() Id_Version = VersionProduit.Column(0) VersionProduit = Me.VersionProduit.Column(2) VersionPro = VersionProduit.Column(2) End Sub
Additionally, I recommend adding "option explicit" at the top of the module, you will see that VersionPro does not exist.-
-
Contributor@MathisLRNmaybe you didn't save the code changes?
-
-
Contributor@MathisLRNCan you share your corrected file?
-
Yes, here it is: https://cjoint.com/c/HFzo5lTSPGw
-
