General information
Category:
Coding, syntax & commands
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only