Solved

Scroll - Multiple Subform in Main form

Posted on 2011-03-13
5
372 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

770 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