Hello to all
I have table like S_record having fields like(Roll_no,maths,physics,chemistry)
I was created one query having Roll_no and maths
and i created a form having name Form1. in this i a have text box using for search having name ss, and added query to this form
in query i given roll no with criteria [forms]![form1]![ss]
then i put after_update to ss field with requery..
my problem is when i was enter a roll_no in search field ss then the search number is only display in sub-query in form1
then after entering the tab its moving to next empty record,
but my question is after enter the marks in sub query in form1 then controls moves to automatically search field ss
again a enter another roll_No then controls moves to marks filed then when i was enter the marks controls moves to search field i tried this thing but after entering the marks controls moverss to next record. but my intention is to control moves to search button after entering in search button then marks field then after search like that.\ Any body please sujjest me