Help with Combo Box Update

[darrenislearning]

Hi, I have a deactivate user form and the form is able to update the deactivation status.

However, I faced this problem and need some advise
1) After I update, my tblUser first record user name is changed (E.g. after i update amy, the first row record user will change to amy and I will have 2 amy)
2) How to have "Please Select" before showing the list of user
E.g. Please Select
May
Amy
Mable
3) How to set user combo box to "Please Select" as default value after update

 

[arnelgp]

is this what you meant.

 

[darrenislearning]

is this what you meant.

Yes, thank you so much.

 

[Pat Hartman]

You need to use the ID for the where clause NOT a data field, especially one that is not defined as unique. That means that you need to change the RowSource query to select the autonumber as the first field. Change the column count, And, set the contol length of the ID field to 0 to hide it.

I don't know what arnel did for you because I never look at "try this" solutions.