Search a datagrid

[jakeir]

Hi I have a dataGrid(manager ID as one of the fields) and I would like to put a textbox that I can enter a an Mgr ID and when I click the button it I would like the gride to automaticaly go to that record; I am currently using VBA code to fill the datagrid, from a table in SQL Server.
I have not been able to find anything in the grids properties or methods to do this.
Thank you

 

[ZmrAbdulla]

What type of DataGrid it is? Access doesn't have a datagrid except datasheetview

Zameer Abdulla

 

[jakeir]

The datagrid is in Microsoft data grid found in their
Active x tools. I have used it for years, I jsut never had been asked to have away for the user to go right to the record in a serch.

 

[jakeir]

Hi,
I figured it out.
I just made a SQl statement with a where clause to find the Mgrid I wanted and then populated the Datagrid with just that record. I was reall looking for it to go to thoughs record but this works.
But I do wnat to thank you for your help and ideas.
Than you

 

[ZmrAbdulla]

Glad you find it out. I haver never used a grid like this.

Zameer Abdulla