populate a combobox after updating a texfield?

combobox

New member
Local time
Today, 17:38
Joined
Mar 19, 2013
Messages
2
Hello to everyone,
It is my first post on this forum although I have been enjoying it for a long time. Very useful!
I am trying to create a login form with the following three basic fields:
  • txtUsername
  • cboUsertype
  • txtPassword
I would like to be able to populate cboUsertype with User types associated to the user I type into txtUsername. I have found many useful tutorial on the web on login procedures. How ever I hardly found anything on how to populate a combobox after updating a texfield. It bis more than a week that I am trying to find a solution but until now I have just been :banghead:. I would be grateful if you could provide me with either a link on the web or a vb code to make it work.
Thanks in advance
Combobox
 
Welcome to the forum

What you are trying to do is a variation on the Cascading Combo Box theme. The difference being that you are using a text box rather than a combo to cascade from.

The problem I see with this approach is that if your user miss-keys the user name your cascaded combo will be blank. To avoid this why not have the user select their name from a Combo box of available user names?
 
Thank you very much John Big Booty! The link you provided was very useful to me. The logic behind my choice to use a text field rather than a combo box to populate the usertype combo box is not to make public the username of each user unless he/she decides to share it with his/her coworkers. It is an attempt to add an higher level of security to the login procedure. I had already foreseen that if the user would type an erroneous username the usertype combo box would not be populated. I thought, in this case, to trigger a popup window that would inform the user that the username he/she has typed is wrong and to try again the login procedure.

I will post the login database as soon as I am happy with it, or more likely, when I hit another major :banghead

Thanks :)
 
OK that sound's like a good reason not to use a combo, perhaps the addition of some validation on the user name would avoid the issue of miskeying.
 

Users who are viewing this thread

Back
Top Bottom