>Kenneth,
>
>A table has to be open before you can do a SEEK. There are several possibilities on how the table is opened.
>
>Tables can be opened:
>1) In the load method of the form, using the USE command (my preference)
>2) In the Data Environment of the form (right click inside of the form in design mode and choose Data Environment)
>3) Your system may be based on views. Perhaps a view is being opened that has the Product table as the underlying table.
>4) There may be a SELECT statement somewhere that queries the Product table. This would open the table. I guess this SQL Select could be the recordSource for a list box you mentioned.
>
>If your system is using a VIEW to the product table, that would have an impact on how you implement your solution.
>
>If I am missing any other ways the table could be opened, perhaps someone else will fill in the blanks...
>
Steve;

The only other way I can think of is a routine that opens the tables when the exe is opened.

Tom