By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,301 Members | 1,752 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,301 IT Pros & Developers. It's quick & easy.

Vertical Scroll Bar not working in subform

P: 5
I'm using MS Access 2003 on a computer running Windows XP Professional SP2

The problem I'm having is that the vertical scroll bar in my subform won't allow me to scroll down and see all the records.

I'm using a form to select an item from a list then populating a subform from another related table to show all the other items that are linked to the selected item. When I have a small number of related items it's not an issue since they all fit into the subform window, however, when I get more records than can fit in the subform window I can see the scroll bar, but when I go to click on it nothing happens.

On the subform I have Data Entry and Allow Additions set to no, and I changed the Border Style to Thin. otherwise I have left the settings at default. I have tried reseting thoes values to the default with no success.
Sep 24 '08 #1
Share this Question
Share on Google+
3 Replies


missinglinq
Expert 2.5K+
P: 3,532
Right off hand I can't think of what is causing this. What service pack are you running with the Access 2003?

"I'm using a form to select an item from a list then populating a subform from another related table to show all the other items that are linked to the selected item."

It might help us if you explained the above statement a littler more clearly.

Also, you need to understand that setting Data Entry and Allow Additions and other related properties on a form used as the base for a subform is really a waste of time, if the form will only be used as a subform.

Since a subform is actually a control on the main form, its behavior is controlled by how these properties are set on the main form. In other words, if AllowAddions is set to Yes on the main form, it is effectively set to Yes on the subform. There are workarounds for this, but you just need to be aware of this behavior.

Welcome to Bytes!

Linq ;0)>
Sep 24 '08 #2

P: 5
I'm using SP2 for Access 2003.

for the main form I'm selecting a part number from a combo box, the subform then populates with the list of sub parts that exists in the main part that was selected on the main form. I hope this is a bit more clear.

Thank you for the information on the controls I was unaware of that fact. I'm relatively new to Access and having to figure out the details as I go doing this project for work.
Sep 24 '08 #3

NeoPa
Expert Mod 15k+
P: 31,494
This may sound silly, but when I've had similar issues in the past, it turned out that the scroll-bar I was looking at was actually not the effective one for what I was trying to do.

Sorry if that's no help - it was all I could think of without seeing the exact problem.
Sep 25 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.