>Hi everyone.
>New to the board, and to computer coding. Of course, I have run into a problem.
>I am building a form that calls a data table.
>I have a filter set to scan through the table to find a part number. Once all records of that particular part number have been found, I want to populate a cursor with those records.
>I can browse my table and see the cursor on my specified part number. That seems to be ok but, when I try to put the desired information into my cursor, it places ALL of the table's records into the cursor.
>What might I be doing wrong?
>Any help is greatly appreciated!

Hi Chad,

Instead of filter and scanning why not do simple SQL SELECT

SELECT * from mytable WHERE part_number = some_particular_part_number INTO CURSOR myparts

Or, you could have parameterized view of your mytable with the same condition as a parameter, then change the parameter for a part number you need and REQUERY() the view.