Pause code to other code process 1

[nifty001]

I have a subform that posts infor to the one of the same tables that my main form does. I'm hoping to yield the sub forms posting routine to the main forms routine. What is the best course of action.

 

[nomus1]

I am not sure of your application, but I had a situation once where I populated a sub-form based on some information that was entered in the main form.

I had a filter button that the user pressed after they had entered in all the applicable filter information to their lookup.

For the onclick event I wrote a sql statement that combined all the filter criteria. Set my recordsource for the second form to the sql statement, and made my subform visable.

Hope this helps

 

[nifty001]

I'll give it a try.