Solved

Scroll - Multiple Subform in Main form

Posted on 2011-03-13
5
362 Views
Last Modified: 2012-09-17
Hi,

i have 3 sub forms in my main form in a continuous form mode. Currently i am having the vertical scroll bars on the sub forms turned on such that i can scroll down for more records. I there any possible way to have the vertical scroll on the main form linked to the sub form and i would not be able to see the vertical scroll bars on each of the three sub forms

Your help on this is appreciated
0
Comment
Question by:Saichand
5 Comments
 
LVL 84
ID: 35121157
Do you mean you want to "scroll" on your mainform, and have the actual "scroll" process work on your subforms? If so, then not with the builtin Access scrollbars. You might be able to do with a 3rd party control, but I'm not sure how well the implementation would work.
0
 
LVL 19

Expert Comment

by:MINDSUPERB
ID: 35121205
Here's an interesting discussion on the link below similar to what you want. You might get an idea from it.

http://www.utteraccess.com/forum/Synchronize-2-Continuous-t1962738.html

Sincerely,
Ed
0
 
LVL 57
ID: 35121835

 Just to be clear; the subforms are only showing records for the currently selected main form correct?

JimD.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35130537
Just to be clear, "Scrolling" (via the scrollbar) in a form does not necessarily move you through the records (Select each record as you scroll), ...it simply lets your View the other records as you scroll.

This means that if you select the first record, then use the scroll bar to move down, you will still only have the first record selected, but you can scroll down and see the other records.
Hence the main form record will not change, thus not triggering a change in the subform.

Using the arrow keys (Not the scrollbar) to Scroll (move through) the records is another story, ...as this will "Change" (Select) the records as your scroll, thus triggering a change in the main form and in the subform.,

But the key here is your form design,
In a general sense, you cannot have your main form "Scrollable" (Continuous, or Datasheet) if it contains a subform.

So this may all be a moot point.

Let's see what some other experts post...

JeffCoachman
0
 

Accepted Solution

by:
champfrom1984 earned 500 total points
ID: 35130852
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now