Question Help with Subforms on mainform (1 Viewer)

N

nick941741

Registered User.

Local time

Today, 05:43

Joined

Mar 17, 2009

Messages

21

• May 6, 2009

• #1

Hi, I am very new to MS Access but have (with a little bit of help) managed to build an events booking DB for someone. However this will be the first of many posts as I now try to hand it over to my customer (wife)

The database consists of the following main tables

A Clients table
An Events table
A Comms Table - so users can record phonecalls or mail merge


I have a main form that shows subforms on it driven by other queries, using a hidden master ID on the main form so as the user scrolls through the clients the sub forms all update to show related records.

The problem I am having is on this form it shows calculating in the status bar and flickers continuously. Is this bad design, or just something I need to disable?

Any help as always very much appreciated.

Nick

Edit: This is using Access 2003 - I have some basic skills in acces and a little VB

 

Last edited: May 6, 2009

P

Poppa Smurf

Registered User.

Local time

Today, 14:43

Joined

Mar 21, 2008

Messages

448

• May 6, 2009

• #2

This is normal when queries are used. In your case as the user moves from record to the next the queries run and re-calculate the displayed while this is happening you will see Calculating .... displayed on the Status Bar.

 

N

nick941741

Registered User.

Local time

Today, 05:43

Joined

Mar 17, 2009

Messages

21

• May 7, 2009

• #3

Thanks for the reply. Is there a better way of doing this then?

It tends to slow things down quite a bit and doesn't look great either.

Nick

 

P

Poppa Smurf

Registered User.

Local time

Today, 14:43

Joined

Mar 21, 2008

Messages

448

• May 7, 2009

• #4

My question is Why does the user need to Scroll through the list?

You could use a combo box on your main form to select a customer.

 

N

nick941741

Registered User.

Local time

Today, 05:43

Joined

Mar 17, 2009

Messages

21

• May 13, 2009

• #5

Sorry for the delayed reply.....

So, would using a drop down list stop the recalculating then?

There is no real need for the user to be able to scroll through the list as there will be too many clients for them to just scroll and select. I have added a quick search on surname field to the mainform too. So maybe a drop down would be easier to do.

Nick