Whats Quicker? Bound vs UnBound

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

DS

I'll be using this over a network.
What would be quicker?
A Bound Form or....
An Unbound form with SQL to Insert and Update the records Accordingly?
Wouldn't the Unbound load faster also?
Thanks
DS
 
It depends...
Sure if you have a bound form that reads in the whole table it will be slow.
I always use a 'search form' before my main update form. It opens a
recordset for only the records desired, then opens the main form with a
filter on only a single record at a time.
Unbound forms are a hell of a lot of work.. take it from me, I've tried it.
Just getting the controls to accept the right length of data is a major pain
and will have you pulling out your hair.

Dorian
 
mscertified said:
It depends...
Sure if you have a bound form that reads in the whole table it will be slow.
I always use a 'search form' before my main update form. It opens a
recordset for only the records desired, then opens the main form with a
filter on only a single record at a time.
Unbound forms are a hell of a lot of work.. take it from me, I've tried it.
Just getting the controls to accept the right length of data is a major pain
and will have you pulling out your hair.

Dorian

:
Click to expand...
Thanks,
The Main Form is for inputing new records only, It has a listbox on it
that shows the updates, and when it does go to an old record it shows
only one at a time. I just heard that SQL is FAST, so I thought that I
would try that. I just discovered Dim, So now I don't have to hide
textboxes all over forms to carry over data, so with all of this new
knowledge I'm trying to make my form as Fast as possible.
Thanks for the Input
DS
 
Back
Top