Make table Query

[kpryan]

Hi all
On a form I have a text box which I am able to open a form by this code;
"DoCmd.Openform "form42", , , "acctno=" & "'" & Me.AcctNo & "'"

The acctno selects an account so all records can be viewed. I would like to be able to use a make table query so that just the records from a Acctno can be stored into that table.
I know I could use an append table, but not sure which is best.
Can the above code be used to creat an append table or a make table query.
I have tried using the above code with no results.

Many thanks,

kp

 

[fneily]

You'd use a parameter query referencing the acctno control. So in your query on the criteria line below acctno you'd have Forms![form42]![acctno]
This query would be a make table query. You can turn off system messages by using the Setwarnings command.


But, why would you want to do this? It serves no purpose as stated, it's bad database design, and it'll bloat your database everytime it's run. I'd advice against it.