MemoryReferences

[Idris]

I have a unbound Form for Data entry and wish to save the few fields data for immediate call back at a press of a key in next posting - The are many ways I can do it in Access - but which would be the best/Idealistic way to deal this action.

I can create and use temp table
I can create and use listbox
I can create and use Array(7,100)
I can create and use createobject scripting dictionary

This data is a temp and has no relevance with the actual data.

Please comments and advice - Thanks

 

[pono1]

What are your priorities? Performance? Ease of use and long term maintenance? Reliability? Once you identify these sorts of things you'll be able to choose the tool that's best for your task.

If you believe what you read, a temp table would probably be the slowest -- on the other hand, Access provides many tools to work with tables and it may not be prohibitively slow if it's a local table. Arrays and dictionary objects are of the same cut of cloth -- depending on the person and task, a dictionary object might be easier to use and maintain. If you can't decide, you may want to take a day or two to create some throw-away prototypes...

Regards,
Tim