S
sam
Hi All,
I have an excel userfom with a text box that accepts Student_ID. Once a
student inputs ID in this textbox, other form fields like Name, Address,
Ph_No will auto populate.
The button to launch this form is on Sheet1 and the students data that auto
populates is in sheet2.
NOW, There are instances where new student data is not available in Sheet2
until I manually update Sheet2 with their info. So even if students are
enrolled and they input their ID they dont see their Name, Address and Ph_No
autopopulate in the fields. Is there a way where a student inputs the ID and
if his or hers data is not present in Sheet2 the student can manually input
the data which will then populate the Sheet2.
Initially I have kept the Name, Address and Ph_No fields disabled as they
are autopopulated, But for new students if it doesnt autopopulate, I want
these fields to be enabled once a student inputs the ID for 3 times and the
Name, Address, Ph_No fields dont autopopulate.
SO for eg, IF a student inputs "123ef" in the ID fields and the Name,
Address, Ph_No doesnt populate, the student will see a msgbox saying please
input your ID again, This will happen for a total of 3 times, and the fourth
time if the student inputs the Id and the fields dont autopopulate then the
Name, Address and Ph_No fields should be enabled and editable
With Me.Student_ID
Dim i As Integer
If Me.Name.Value = "" Then
For i = 1 To 3
MsgBox ("please re-enter Student ID number")
Next i
End If
Me.Name.Enabled = True
Me.Address.Enabled = True
Me.Ph_No.Enabled = True
End With
Hope I made it clear
Thanks in Advance
I have an excel userfom with a text box that accepts Student_ID. Once a
student inputs ID in this textbox, other form fields like Name, Address,
Ph_No will auto populate.
The button to launch this form is on Sheet1 and the students data that auto
populates is in sheet2.
NOW, There are instances where new student data is not available in Sheet2
until I manually update Sheet2 with their info. So even if students are
enrolled and they input their ID they dont see their Name, Address and Ph_No
autopopulate in the fields. Is there a way where a student inputs the ID and
if his or hers data is not present in Sheet2 the student can manually input
the data which will then populate the Sheet2.
Initially I have kept the Name, Address and Ph_No fields disabled as they
are autopopulated, But for new students if it doesnt autopopulate, I want
these fields to be enabled once a student inputs the ID for 3 times and the
Name, Address, Ph_No fields dont autopopulate.
SO for eg, IF a student inputs "123ef" in the ID fields and the Name,
Address, Ph_No doesnt populate, the student will see a msgbox saying please
input your ID again, This will happen for a total of 3 times, and the fourth
time if the student inputs the Id and the fields dont autopopulate then the
Name, Address and Ph_No fields should be enabled and editable
With Me.Student_ID
Dim i As Integer
If Me.Name.Value = "" Then
For i = 1 To 3
MsgBox ("please re-enter Student ID number")
Next i
End If
Me.Name.Enabled = True
Me.Address.Enabled = True
Me.Ph_No.Enabled = True
End With
Hope I made it clear
Thanks in Advance