How do I create a form that can search using a certain field in a table, and present

[yusufnasir]

I have an examination scenario where I already have all the other details of the candidate. I have reached a point where I want to start entering their examination scores. I am trying to develop a form that will perhaps search using "exam no." and present the various subject fields for me to enter the candidates scores, and the form will keep doing this until I demand to exit.

PLEASE MAKE ME HAPPY

[Seth Schrock]

This is actually not very hard to do. I'll tell you what I think is the simplest method. You would have two forms (frmSearch and frmResults) and a query. In frmSearch you would have a textbox called txtValue. Your query would have all the fields that you want to see in frmResults as well as the [Exam No] field. frmResults would be bound to this query. In the query's WHERE clause, you would put

'If [Exam No] is a number field
WHERE [Exam No] = Forms!frmSearch!txtValue
 
'If [Exam No] is text
WHERE [Exam No] = "'" & Forms!frmSearch!txtValue & "'"

Now in frmSearch, place a button that opens frmResults and then closes frmSearch.

DoCmd.OpenForm FormName:="frmResults"
DoCmd.Close acForm, Me.Name