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
:
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
