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

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?

--
KARL DEWEY
Build a little - Test a little


"tkirchoff15" wrote:

> 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,

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" wrote:

> 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?
>
> --
> KARL DEWEY
> Build a little - Test a little
>
>
> "tkirchoff15" wrote:
>
> > 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
> >
> >

>>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


"tkirchoff15" wrote:

> 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" wrote:
>
> > 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?
> >
> > --
> > KARL DEWEY
> > Build a little - Test a little
> >
> >
> > "tkirchoff15" wrote:
> >
> > > 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
> > >
> > >

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

"KARL DEWEY" wrote:

> >>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
>
>
> "tkirchoff15" wrote:
>
> > 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" wrote:
> >
> > > 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?
> > >
> > > --
> > > KARL DEWEY
> > > Build a little - Test a little
> > >
> > >
> > > "tkirchoff15" wrote:
> > >
> > > > 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
> > > >
> > > >