what form control to use?

C

cd

I want to use a form for the user to enter in search parameters - I
know how to do this.
These parameters are used in a database query.
Then I want to display the results of the database query in the form -
What control do I use for this and could you give me an example of the
vba code I would use to populate it?

Thanks
 
H

Harald Staff

That would imo depend a lot on what kind of database result this is, how big
it is expected to be and what the user is supposed to do with it on a form.
Consider also which controls that are already installed on your users'
systems and your ability to deploy/register extra controls. This tend to
make less capable controls a better choice all in all.

HTH. Best wishes Harald
 
C

cd

Say the results are 20 rows with 4 columns. The user will just scroll
thru the results.

What are my options?
 
C

cd

I'm using the spreadsheet control - it is extremely slow to load.
I have one query that returns 18,000 rows.

When I load the results into the spreadsheet control it takes 224
seconds. (this is the command I am using
to load UserForm1.Spreadsheet1.Cells.CopyFromRecordset rsRap)
Loading to a regular spreadsheet takes 20 seconds.

Any suggestions?
 
Top