display corresponding value textbox value issue

[technocraze]

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

[ADezii]

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

Private Sub TextBox1_AfterUpdate()
  Me![TextBox2] = DLookup("[Name]", "tblStudent", "[StudentID]='" & Me![TextBox1] & "'")
End Sub

[technocraze]

tks MAN! that works great

[technocraze]

Hi AdeZii & community experts,

I would like to knw whether is it possible to reset (empty) the fields at the form load event without affecting the values of the fields? Because StudentId is my primary key, if i rest the field at form load event, the table values got erase automatically. I want to achieve in such a way, whereby, the resetting of fields at form load wont cause any impact of the data in the table.

Another issue that I would like to seek your consultant is to lock the data of the table so that user cannnot edit the values in it. Tks! (insert, update) from form is still allowed jux that dnt allows user to edit the existing records in the table.

Private Sub Form_Load()
StudentId.Value = ""
Name.Value = ""