VB Script help reuired

[accesser]

I want to write a small VB Script code on Data Access Page on MS Access 2000 to do the following

-when Click the Label (A) , I want to load all the data from table AllRecords into table CurrentRecords.

The AllRecords and CurrentRecords tables are Local tables in the Access Database

Regards,

 

[FoFa]

Don't need a script. Create a query to do the data copy for you. Create a macro to run that query. On the control's Click event, run the macro.