What and where are you attempting to find? What criteria are you applying and what are you wanting to update? Its a bit like asking "How to I get to London?" If we dont' know your mode of transport, where you are travelling from? Where in London do you want to go? it implies we are mindreaders. Some of us think we are but in real terms we can only guestimate.
thanks Crake, i have a data for student and want to search for student a from 1000 records, i know i can scroll through my data or use command button find record. But is there a way I can do it with VBA.
Thanks