Combobox very slow to fill form

[AFCDons]

Hi,



I have inherited a database that is running really slowly at certain points.
There is a combobox that has a SQL select for the source row that returns the 4600 records very quickly.
When I select a record from this drop down it can take up to a minute to fill the form below.
If you use the arrows at the bottom it scrolls through each record immediately and it's the same if you enter a record number and hit enter.
There is a macro for findrecord and this is also very slow.
Can anyone give me an idea where to start looking as I thought that once it was in the combobox it was ready for selection.

Any help appreciated.

thanks
John

[pbaldy]

What happens if you hit the last record button at the bottom? My guess is that the form has loaded a few records and shown you the first record, but hasn't bothered to load the whole table (different animal than the combo rowsource).

4600 isn't really that many records though, so I'm curious what the test above reveals. I might switch to a method that sets the form's source to a single record when you select from the combo.

[AFCDons]

Hi Paul,

Thanks for the quick reply. It moves straight to the end of the record set 4605. It's strange as I can't work out if they are loaded why it takes so long.

thanks
John

[pbaldy]

What's the code behind the combo?

[AFCDons]

It's a very simple select query. It pulls through 4 fields from one table. No filter, all the records from the table. There are 4 combo boxes, one for each field.

cheers

[pbaldy]

I meant the code or macro that runs when you make a selection. That sounds like the row source.

[June7]

What do you mean by 'fill the form'? What is the code (macro or VBA) behind the combobox that accomplishes this? Are you setting form RecordSource property? Or is the RecordSource a dynamic parameterized query referencing the 4 comboboxes and the code only requeries the form?

[pbaldy]

I will get out of June7's way.