Delay in subform navigation buttons showing total.

[raward1941uk]

I have created a form with 2 nested subforms in it for storing order details. The main form shows the customer, date, and his/her order number. The first subform displays items ordered, one record at a time. The second subform embedded in the first subform shows details of subcontracters and prices.

When I click through the orders on the main form, there is a delay on the first subform navigation buttons showing the number of items, which may be 1 second for 4 items. At the moment my orders table has 17 orders in it and my items table contains about 45 items. I can see a serious problem when both tables have many more entries.

Has anybody any suggestions?

Roger Ward

 

[ajetrumpet]

Well,

what is the VB syntax you are using when you switch records in the main form (if any)? I wouldn't think that a simple relationship between tables would do this. As a matter of fact, I know it doesn't....

 

[raward1941uk]

When viewed in data sheet view the result is instantanious but when viewed as a single form the delay is quite marked I can assure you.

 

[ajetrumpet]

What's the code behind the form? Did you check that? Not all code applies to all the different views...

 

[raward1941uk]

Re: Delay in subform navigation buttons showing total.

Adam,
Thanks for your interest which I appreciate. I was going to attach a Zip file of the database but I can only get it down to 540K and I see that the limit for Zip attachments is 393K. However you have helped me enormously because at the moment I am using a main form with a subform embedded in it, and I see now I can use a single form with the data obtained from a complex query.

Many thanks
Roger Ward.

I will get there in the end!

 

[ajetrumpet]

Whatever works Roger. Good luck with it!

 

[raward1941uk]

It works fine!