Creating Tables - AutoNamed at run-time

[journeyman]

Hi,
Can anyone help?

I'm creating an on click event which will copy an existing table and rename it.. so far so good. However I'm trying to auto increase the number for the new table.

The script I was using to change the name was DoCmd.Rename but this seems to require a unique string in "" and will not take a variable.

I had hoped to grab the new table name from an autonumber in another table.

Any ideas?

 

[dynamictiger]

Have you tried code something like:

intAutoNumber=DMax("Number","table&quot+1

strTableName="MyNewTable" & intAutonumber

Docmd.Rename strTableName

 

[journeyman]

Hi dynamictiger
something like your suggestion has done the job - thank you