Make Table Query-Running a make table query before you open a for

[tkirchoff15]

Hello .... what is the cleanest way to run a make query before you open the
form that has the make table as the control ... Is a VB macro needed.. if so
do you have an example of the VB marco for the task . Thanks...T

 

[KARL DEWEY]

Please clarify your reqirement as your phrases do not match my knowledge.
-- run a make query Do you mean to run a make TABLE query?
-- form that has the make table as the control What kind of control is
this? What is the name for such control?

 

[tkirchoff15]

Karl,

We have a query (MakeTableQuery) that creates a new table (InputTable) from
3 tables. This query uses 2 fields from Form 1 to create the InputTable. The
InputTable that is created from the MakeTableQuery is the input to Form 2.
For the flow of the process: On form 1 we have a command button that opens
form 2. We need to add the MakeTableQuery before we open Form 2. We need the
VB code to make this happen. We do not know how to code a Make Table procee
in VB.

Thank you for your help.. T

 

[KARL DEWEY]

On form 1 we have a command button that opens form 2.
Suggest using a macro to run the make table query and to open the form. The
command button on form1 can call the macro.

 

[tkirchoff15]

I built and tested a litle and it works Thanks again for your help