?
Solved

Scroll - Multiple Subform in Main form

Posted on 2011-03-13
5
Medium Priority
?
401 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 85
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 58
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 1000 total points
ID: 35130852
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

752 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