Subform slownes - Microsoft Access / VBA

MFS 43

I noticed one of my forms was loading very slowly. I have now figured out that
if I remove one of the subforms on this form, this problem disappears.

I have tried basing subform on a query and have indexed link field in the
subform - this does not help. Incidentally subform is not large.

Any suggestions to make this run better?

Thanks for the help in advance.

Nov 12 '05 #1

Subscribe Post Reply

1109

Edward

mf***@aol.com (MFS 43) wrote in message news:<20***************************@mb-m04.aol.com>...

I noticed one of my forms was loading very slowly. I have now figured out that
if I remove one of the subforms on this form, this problem disappears.

I have tried basing subform on a query and have indexed link field in the
subform - this does not help. Incidentally subform is not large.

Any suggestions to make this run better?

Thanks for the help in advance.

Without code or SQL it's hard to be emphatic. However, I have had
similar problems which occurred because I had code which repeatedly
fired the Form_Current event. Try putting a breakpoint in the
Form_Open event (the first event that fires) and see what is
happening. If there is nothing untoward, you may need to look at the
query.

Edward
--
The reading group's reading group:
http://www.bookgroup.org.uk

Nov 12 '05 #2

Similar topics

How to check if subform is dirty

by: Rey | last post by:

Howdy all. Appreciate your help with several problems I'm having: I'm trying to determine if the Visit subform (subformVisits) has a new record or been changed, i.e. dirty. The form that...

Microsoft Access / VBA

Recordset in subform based on field in parent form

by: Lyn | last post by:

Hi, I am working on a genealogy form. The only table (so far) lists everybody in the family, one record per person. Each record has an autonum ID. The parent form (frmMainForm) displays the...

Microsoft Access / VBA

Setting a value in a subform

by: John Michael | last post by:

I have a form that has a subform that has a subform. The subform loads a record based on a combo lookup box in the main form. I'm trying to set a value in the subform based on a value in a...

Microsoft Access / VBA

Main Form & Continuous Subform (with Requery) Problem

by: Dave Boyd | last post by:

Hi, I have two very similar forms each with a subform. The main form gets a few fields from the user and passes this back to a query that the subform is bound to. The requery is done when the...

Microsoft Access / VBA

How to refer to the control on the second subform

by: MP | last post by:

I have a main form that has a subform which also has a subform: the main form is the first subform is the second subform is When I click on the button »AddNewSubSubRecord« (add a new record...

Microsoft Access / VBA

Pass subform name to function or sub

by: DMUM via AccessMonster.com | last post by:

Hello I am trying to pass the name of my subform to a function/sub but I can't seem to get it to work. I am using an autokey function (ctrl E) to unlock text boxes on a subform. I have a few...

Microsoft Access / VBA

Updating subform records after closing popup form

by: Macbane | last post by:

Hi, I have a 'main' form called frmIssues which has a subform control (named linkIssuesDrug) containing the subform sfrmLink_Issues_Drugs. A control button on the main form opens a pop-up form...

Microsoft Access / VBA

Tab Control and Dynamic subForm Linking

by: ApexData | last post by:

I am using the following code in my TabControl to manage subform loads. The code assigns the subForms SourceObject. - Do I also need code to DeAssign the SourceObject when leaving the Tab, I'm...

Microsoft Access / VBA

Help with Linking Combo boxes in a Subform

by: samdev | last post by:

I have created two combo boxes in a subform.... For example 1. Combo Box State 2. Combo Box City 3. When a state from the Combo Box State is selected, the City combo box updates to reflect...

Microsoft Access / VBA

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA