Hi all,
I am using the form object in the data menu in excel to access my data. But the problem is that every time I open up the form, it starts at the very first record. Actually I used the showdataform method in vba to do that. Is there some way I could direct the form to start at the current record rather than at the first record. I dont want to hit the criteria button every time. I dont know how to access the built in form object in excel. Anybody has any ideas.

Thanks,

Sunil.