Store data in an application

[JONBOY74]

Hi all

Sorry if this is a stupid request....

I would like to store list of data from a recordset in an app I'm trying to build, and use it at a later date.

I've been trying with arrays....is this the way forward?

Any help would be use full

PS I only want to open the rs once (on open)

 

[johnwm]

How much data are we talking about?
Will it ever change?
When you say 'use it at a later date' what exactly do you mean?

With these answers we may be able to help Let me know if this helps
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'There are 10 kinds of people in the world: those who understand binary, and those who don't.'

 

[JONBOY74]

I'm looking to store 2 to 3 list of data consisting of about 10 items within the code.

When I click a button relating to the required list that data populates a combo box. If I click another button then the same combo box is populated by data from one of the other lists ( and the old info is cleared)

The list sizes can be increased & decreased in the database. The idea is that when then apps is load the rs is run, data retrieved and the closed

Does that help???

 

[zemp]

"The idea is that when then apps is load the rs is run, data retrieved and the closed"

Seems like you answered your own question. If the data for your list exists in the database then theere is no need to store it elsewhere. As you said, when the app is loading use a recordset object to get the data and populate your list. Repeat with different data when a buton is clicked. Thanks and Good Luck!

zemp