Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

Thread Tools Rate Thread Display Modes
Old 08-06-2013, 02:44 AM   #1
Newly Registered User
Join Date: Feb 2013
Posts: 66
Thanks: 12
Thanked 1 Time in 1 Post
Futures_Bright is on a distinguished road
Click Locked/Disabled controls, prompt for variable

Hi all,

I have a form for reviews ("Review") which locks and disables almost all controls when the review is verified. On this form is a sub -form ("ReviewDocSubForm") which shows related documents to the review in a continuous format; all controls on this form are locked/disabled by default and the user edits a particular 'line' by clicking a button on each row with the following code to open up another form:

DoCmd.OpenForm "DocLink", acNormal, , "[DocLinkID]=" & Me.DocLinkID & ""
To clarify, the subform is the only control on the "Review" form which is locked/disabled other than the 'Tab Controls' for the "Review" form.

I've noticed that on verified reviews (i.e. where the controls can't be edited) that when I click on any control a prompt box comes up asking for:
and I can't work out why. This occurs both when there are records on the continuous subform (i.e. there is an entry for DocLinkID, key field) and also when there are no records

The button mentioned above is the only place in my code which calls up this control - I can't work out why this is prompt appears, any suggestions so I can stop this messagebox appearing?

Futures_Bright is offline   Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Locked / Disabled Hyperlink?? access7 Forms 1 11-18-2011 05:42 AM
Locked controls - how to warn that control is locked darbid Modules & VBA 7 02-08-2010 05:03 AM
Disabled and Locked Textboxes kevygee Forms 2 06-10-2005 07:17 AM
Locked/Disabled Combo wodonnell Forms 2 11-23-2004 07:53 AM
how to search on a disabled/locked control arage Forms 1 08-15-2001 07:45 AM

All times are GMT -8. The time now is 04:21 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World