Very Novice User needs HELP with Form

[Insanity Queen]

I am trying to create a form that finds the record when the student types in their id number, then populates the rest of the fields on the form with the information in the table. Additionally there needs to be a few fields that the student must complete the first time around since we don't have all the information.

[maximus]

I have two tables tblStudent and tblForm

I have a form whose record source is tblForm. There is an unbound textbox on the form in which the user has to type a StudentID after which clicking on the autofill button the Similar data from the tblStudent is pulled out and is used to populate the form:
Code used in the Auto Fill Button:


Dim intStudentID As Integer
Dim strSQL As String

If IsNull(Me.Text13) Then
MsgBox "Please type an ID"
Else

intStudentID = Me.Text13
strSQL = "Select * from tblStudent Where StudentID=" & Me.Text13

Set rs = CurrentDb.OpenRecordset(strSQL)
If rs.EOF And rs.BOF Then
MsgBox "N Record for the ID typed"
Exit Sub
End If
Me.StudentName = rs!StudentName
Me.DOB = rs!DOB
Me.GradeNo = rs!GradeNo
rs.Close
Set rs = Nothing
Me.Text13 = Null
End If


pls refer to attached mdb file. (Type Number between 1 to 3 coz only three names are entered in the student table)

if this solves your problem mark this thread solved.