Create name based on control value for Make Table Query

[Drenda]

Can you please help

Is there a way to create a make table that is named dependant on the value of a control on a form. For example I have created a log in form with 4 users and may add more in the future and the name of the make table would be dependant on the user logged in so.....

User A logs in a table called user A is created
User B logs in a table called user B is created

and so on

Many thanks in anticipation of any help!

 

[PHV]

What have you tried so far ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Drenda]

Thanks for the response

Unfortunately not much - have been scanning the internet for tips and thought I might get some pointers

 

[Drenda]

I have now tried the following
SELECT [Auth Req Name tab test].*
INTO [User Name] (This should be the control name but resulting table is called user name)
FROM [Auth Req Name tab test];

 

[PHV]

In VBA:
DoCmd.RunSQL "SELECT * INTO [" & Me![User Name] & "] FROM [Auth Req Name tab test]"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Drenda]

This is excellent - one more queston - is there any way I can set a primary key

Many Thanks