Run Make Table query automatically

[tuna]

Hi, is it possible to run a Make Table query automatically on opening another query (who takes values from the table created by the Make Table query)?



Thanks

[maximus]

Questions:
1) What do you mean by Make Table Query.
2) Do you want to create a table and then populate it with the values in a Query.
3) Or You want to Create a Query that will Display will display all or some data in another Query.

A little more details may be an explanation with example will be helpful.

Both are possible.

[tuna]

Thanks. I think Access calls it a "Make Table" query but it's a SELECT ... INTO query - I just need this action query to run when another query loads since I will be using the newly created table (from the action query) in that query.

Any ideas?

[maximus]

Sure I have Ideas

examine the following code:

Private Sub Command0_Click()
On Error GoTo Err_Command0_Click

Dim strSQl As String

strSQl = "Select MemberId,M_FirstName,M_LastName,State,City Into member_d From Member Where City='Kolkata'"
CurrentDb.Execute strSQl


Exit_Command0_Click:
Exit Sub

Err_Command0_Click:
MsgBox Err.Description
Resume Exit_Command0_Click

End Sub

Attached to a command button of a Form. This code Do the following:
1) Create a New Table member_d
2) Append all Data from Table Member Whose for which City Field is 'Kolkata'


if this solves your problem mark the thread solved.

[maximus]

if your problem is solved mark the thread solved.

[maximus]

if your problem is solved mark the thread solved.