> If anybody can help it would be great!
> I have a form that changes record source at run-time.  I need to design
> code that can take the current record displayed on that form cut it and
> paste it into another table based on some defined criteria.  I have
> searched my list of macros and code and have not come up with a
> solution.

> A query is the source of the record on the form and the record needs to
> be pasted to a table.

> Thanks!

> You can make a macro with the RunSQL action. As SQL statement you can use INSERT INTO Table VALUES(FormField1,
> FormField2,.......).

> > If anybody can help it would be great!
> > I have a form that changes record source at run-time.  I need to design
> > code that can take the current record displayed on that form cut it and
> > paste it into another table based on some defined criteria.  I have
> > searched my list of macros and code and have not come up with a
> > solution.

> > A query is the source of the record on the form and the record needs to
> > be pasted to a table.

> > Thanks!