Solved

Scroll - Multiple Subform in Main form

Posted on 2011-03-13
5
393 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
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…

737 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