If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
ACC2007: SubForm slows down form
Hello,
i have a form which is connected to a query with about 6000 records on sql server. If i open that form, it is really fast. But If i add an empty subform on this form, the form opens in 12 sec. What i've seen is, that without the subform the record counter on the bottom only shows the current record but with a subform on it, it seems that it loops through all records and the shows "1 of 6000". Any ideas why there is a difference? I also tried to make the subform invisible or disable it, but the behaviour is the same. Regards Andi |
Thread Tools | |
Display Modes | |
|
|