preloading information from table in combo box

[Guest_imported]

greetings!

I would like to know if there is anyway of preloading a combo box with records in a table. I have a combo box set up with a SQL statement pointing to records in a table and this table has around 30000 records, which means everytime someone goes to use it, it has to run this query that takes way too long. I would like to know if I can run the query and/or fill the items in the combo with data BEFORE the person clicks on it?

 

[ghubbell]

Try this:
In your forms "Load" event in VB type:
Dim LgCount As Long
LgCount = Me![NameOfCombo].ListCount

This forces Access to get all rows at that event, not wait 'till someone uses the combo. Gord
ghubbell@total.net