Results 1 to 2 of 2
  1. #1
    95DSM is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Jul 2010
    Posts
    37

    scroll through subform, disable it though

    I know how to disable a form by making enabled set to no/false. But how can I disable the subform but allow users to scroll though it. Each cell in the subform has a multiple options. So if the user clicks on the cell a combobax appears with the other options. They cant click and change the data, but it looks bad. I want the user to be able to scroll through the subform only, not able to click anything.

  2. #2
    pkstormy's Avatar
    pkstormy is offline Access/SQL Server Expert
    Windows XP Access 2003
    Join Date
    Mar 2010
    Location
    Madison
    Posts
    682
    I believe if you "lock" the form it still allows you to scroll.

    me.mysubformname.locked = true
    or
    Forms!MyMainFormName!MySubformName.Locked = true

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Report and automatic scroll
    By krandall in forum Reports
    Replies: 1
    Last Post: 08-02-2010, 06:27 AM
  2. Help on macro to scroll one record back?
    By getholdofjoru in forum Forms
    Replies: 2
    Last Post: 06-19-2010, 03:01 PM
  3. Adding Scroll bar to a form
    By Kesar in forum Access
    Replies: 1
    Last Post: 06-02-2010, 02:57 PM
  4. Replies: 1
    Last Post: 06-02-2009, 04:44 PM
  5. Auto Scroll in a Form
    By delliott777 in forum Forms
    Replies: 0
    Last Post: 05-31-2008, 07:02 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums