-
display corresponding value textbox value issue
Hi community experts,
May I knw whether is it possible to display the corresponding value of the second textbox based on the user input in the first textbox? This means that once the user enters the value of first textbox - S1, the corresponding matching value based on first textbox will be displayed in the second textbox automatically.
I have tried using the AfterUpdate() event of textbox1 control to trigger this scenario but doesnt seem to be working. Perhaps that is not the correct event for this scenario.
Alternatively, I have also thinking of using two contols for this scenario, textbox and combo box respectively. Textbox will accept user input and combo box will populate or filter the result (corresponding value) based on the first textbox. Hence, nt too sure as to how that can be achieved. Hence, any advice, direction or code snippets are very much appreciated!
Scenario
Student table
StudentId S1 S2 S3
Name Peter Shaun Alfred
Student table view
StudentId - datatype(text), primary key
Name - datatype(text)
Form design
Student profile
StudentId - unbounded textbox1
Name - unbounded textbox2
or
StudentId - unbounded textbox1
Name - unbounded combo box1
-
I used a table a query and a form using a dropdown menu. I'll try to put something together so you can see what I trying to say.
Gary
Last edited by GaryB; 02-02-2007 at 06:14 PM.
-
My last post left a lot out of what I did. I made a quick version of it in a simple database that you can look at and maybe it will help. Any way I hope so.
Gary
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules