Re: Unbound list box in a read only form

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Rli wrote:
Thanks rkc...this looks promissing....
but does this prevent the user to click on for instance a 'delete-record' button?
i will give it a try 

You've probably figured this out by now, but what the loop does is
lock all the controls on the form who's module it is run from. That
includes locking the subform controls which in effect locks the
controls on the subform's form. It's easy enough to unlock a control
on the main form. Unlocking a control on a subform would take some
re-tooling.
.

Relevant Pages

  • Re: Lock and Unlock a Form
    ... out your code so that now I can unlock and lock a form. ... I have added some disabled controls to the exception list, however, i am ... having trouble referencing disabled controls on a subform. ...
    (microsoft.public.access.formscoding)
  • RE: Disable other field in form
    ... if you know VB syntax (I dont) then you could loop through the controls ... > select name first then unlock other 4 fields. ... > screen and lock it. ...
    (microsoft.public.access.forms)
  • Re: Prevent edits - unexpected effects
    ... When you click the button to lock the form, it attempts to save the record ... Allen Browne - Microsoft MVP. ... I've had a chance to implement this code and controls onto my form ... Therefore the subform control is locked well. ...
    (microsoft.public.access.forms)
  • Re: Prevent edits - unexpected effects
    ... You place the code into the events of the form you want to lock. ... > any edits to a record once the checkbox is selected. ... >> Setting AllowEdits to No for a form affects all controls on the form. ... So, if you tell it not to lock your subform, it leaves it ...
    (microsoft.public.access.forms)
  • Re: Prevent edits - unexpected effects
    ... When you click the button to lock the form, it attempts to save the record ... Allen Browne - Microsoft MVP. ... I've had a chance to implement this code and controls onto my form ... Therefore the subform control is locked well. ...
    (microsoft.public.access.forms)