Pull values from a text box on click

[ragavisr94]

Hi,

I want to pull values from a text box during the button on-click event in a form and store it as a new make table function.

Or

While clicking the button, I want to use the values in the text box to create a new table and show as output.

Any help would be appreciated.

[zmbd]

1) Make table action queries are usually very inefficient usage of an Access database unless archiving information - they simply are not large enough to benefit from the subset.

1a) Nothing adds bloat to an Access database better than a lot of make-table-queries leading to all sorts of performance issues and eventual corruption of the database.
- Please take a few moments to explain what you are trying to do with your data. There may be a much better way to accomplish your task.

2) Making the table and showing the results is trivial.
So what do you, to just make the table - or do you want to make the the table and show the results.

To me, the second option sounds more like something that would be best handled by a query.