UnBound Fields

  • Thread starter Thread starter DS
  • Start date Start date
D

DS

I have a form with 20 Unbound fields on it. They are all hidden. At
one point or another they hold information that other actions are based
on. My question is...Is there another way to hold this info? Would my
form be faster if these were on another form that was hidden? Or is
there a completely different way to do this.
Thanks
DS
 
There are several alternatives - you could use 20 form-level variables, or a
single form-level array, collection, user-defined type or class, to name but
a few. However, it is probably unlikely that this would make any great
difference to performance. A few simple text boxes more or less is unlikely
to make a huge difference, it is complex controls such as combo boxes and
subforms that are more likely to impact performance.
 
I think you are doing it the best way. Without more details, its not possible
to suggest anything else. You could hold the information in a table or
recordset or global variables. All those options come with their own set of
problems and would probably be less efficient.
What are you trying to achieve? What does the form do?

Dorian.
 
mscertified said:
I think you are doing it the best way. Without more details, its not possible
to suggest anything else. You could hold the information in a table or
recordset or global variables. All those options come with their own set of
problems and would probably be less efficient.
What are you trying to achieve? What does the form do?

Dorian.

:
Click to expand...
Just Speed, I'm worried that 20 Unbound Fields are too Many.
Thanks
DS
 
Brendan said:
There are several alternatives - you could use 20 form-level variables, or a
single form-level array, collection, user-defined type or class, to name but
a few. However, it is probably unlikely that this would make any great
difference to performance. A few simple text boxes more or less is unlikely
to make a huge difference, it is complex controls such as combo boxes and
subforms that are more likely to impact performance.
Click to expand...
So it seems that this is the simplest and maybe the least problimatic!
But isn't 20 a lot?
Thanks
DS
 
If you'd like to explain how and for what purpose you are using them, it is
possible that someone might be able to suggest a better way.
 
Brendan said:
If you'd like to explain how and for what purpose you are using them, it is
possible that someone might be able to suggest a better way.
Click to expand...
They hold a value from a listbox. So if the unbound field holds this
value then this happens when click on a command button...so on and so
forth...it all works, I was just looking for perhaps a better way, my
main concern is that I thought 20 unbound fields on a form would slow it
down.
Thanks
DS
 
Back
Top