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

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

Post by dGtpcmNob2 » Sun, 15 Apr 2007 05:38:02


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
 
 
 

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

Post by S0FSTCBERV » Sun, 15 Apr 2007 06:36:01

>>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.
--
KARL DEWEY
Build a little - Test a little

 
 
 

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

Post by dGtpcmNob2 » Sun, 15 Apr 2007 07:50:02

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