data control to display only certain records

[Bebe]

i have a subroutine that prompts the user for a case number; if they type in 000000 i need all the cases w/ 000000 to show up in the form and the user can click the arrow on the databound control to go through only the records with a case number of 000000

also how could i show all these records using a grid; i need a number they input to pull up a grid w/ all the records relating to that inputted number; like the 000000. So every case number w/ 000000 would appear in the grid. It needs to be exchangeable though depending on what number is entered by the user.

Need serious help!!!!

Thanks

[karunakaran]

Hi,
While you setting the recordsource property for the data control use the sql with like operator. Then you will have all the records with the number entered in the text box.

thanks
karun