>Hi,
>Thank you for your reply but how to put new tables at runtime as a data environment in a form?Thank you.
>
>Regards
>
>Syah N
You can open tables at runtime with the USE command. If you need to open more than one table, you need the SELECT command to select a free work area (otherwise, opening one table will close another table). If you have controls that refer to the tables (through their ControlSource property), you should do all this in the Form.Load() event.
Example:
use Table1
select 0
use Table2
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)