 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2007Lock a subform but still scroll
I have a couple forms with subforms on them that are basically quick view info only. I don't want anybody to enter information on the subforms or alter the subform in anyway. However, the subform only shows so many records. I still want the user to be able to scroll down the list if they need to. Locking doesn't allow edits of info but the subform columns can be altered. Changing Enabled to No prevents any movement including the scroll bar. Is there any way to make the subform read only but still scrollable?? Thanks for any help You can always set the text boxes Enabled property in the sub form to No That way the user wont be able to set cursor in the text box, and the scroll will work  SignatureGood Luck BS"D > I have a couple forms with subforms on them that are basically quick view > info only. I don't want anybody to enter information on the subforms or [quoted text clipped - 4 lines] > bar. Is there any way to make the subform read only but still scrollable?? > Thanks for any help On May 16, 4:58 pm, Ofer Cohen <OferCo...@discussions.microsoft.com> wrote: > You can always set the text boxes Enabled property in the sub form to No > [quoted text clipped - 15 lines] > > - Show quoted text - Pixie78, You might also try setting the Allow Additions, Allow Edits and Allow Deletions properties of your subform to false. This will all full access to the information but will not allow the use to add new records, make and edits or changes to the data, and now allow deletions of records. Hope this helps. Mr. B Fabulous, thanks for the help, I knew I was overlooking something simple =) > On May 16, 4:58 pm, Ofer Cohen <OferCo...@discussions.microsoft.com> > wrote: [quoted text clipped - 29 lines] > > Mr. B |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.