Hi,

I have the following scenario of using a lookup on a form:

I have a user control that has a text box and a button. The user control resides on the form (call it parent form). When user clicks on the button a modal form (call them Lookup form) is opened with a grid showing data from a database table. This data is in a dataset that is retrieved from the database via call to a stored procedure. The dataset can be retrieved when the Lookup form is instantiated. The problem is that user clicks on a lookup button and selects an item from a lookup form, then closes it (moving to another control on the Parent form). So every time user clicks on a lookup button the program has to make a trip to the database to get the data.

Is there a way to make the retrieved data set remain in the memory in order to minimize trips to the database?

One scenario I am thinking is that the data set can be retrieved in the parent form. Then I would assign the data set to a field of the parent form. But how would the lookup form (the one called from click on the lookup button) would have this dataset "visible"?

Any suggestions will be greatly appreciated.