Re: Locking subforms

Malcom

In the parent form, I lock the prior months depending on the current date. I
noticed that I had to either unlock or lock the fields depending on the date
range since I can change years on the form.

What I have in the child/subform is a status field. I want to check if the
status field for "Closed" and lock the data for that project else I want the
current and future month's fields to be unlocked.

If I set the allowedits to true or false, will that unlock the fields I just
locked in the parent form? What will happen If I have a closed project, will
it automatically go to the next one or 1st one if that is the last project?

John

"Malcolm Cook" wrote:

>
>
>
> "jbruen" <jbruen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:C805E386-5D7B-444E-BBAD-361DFDCB28FC@xxxxxxxxxxxxxxxx
> > I have a form with a subform. Depending on the current date, I locked the
> > prior months fields from the main form.
>
>
> >Depending on a field in the subform,
> > I want to lock all fields for that row. Is there any way to do this?
>
> use the subform's on current event procedure and set the .allowedits to true
> or false depending on your date range test
>
>
>
.

Relevant Pages

  • Field Lock
    ... I hope some one can help i have a combo box and depending what i select from ... it it should lock or unlock a field for editing how is that posible ...
    (microsoft.public.access.forms)
  • Re: Lock Table
    ... Depending on how often you run this procedure, ... executing a SELECT from within the transaction that encompasses all rows. ... > is to place an exclusive lock on the table until the whole ... > put all the update commands in the same transaction as ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: [BUG 13245] - possible circular locking dependency detected
    ... workqueue or in this case depending on a lock that was used from the ... notifier indirection calls cleanup_workqueue_threadwhich flushes the ... workqueue so needs the fake "events" lock. ... end up using (depending on something that uses) cpu_add_remove_lock. ...
    (Linux-Kernel)
  • Re: Locking subforms
    ... I put the following logic in the oncurrent event and it turned al ... projectname's red and locked all rows in the subform. ... I only want to lock the row of data with "Project ... Depending on the current date, ...
    (microsoft.public.access.setupconfig)
  • Re: Making munu-items not accessible.
    ... Depending on the user i wish to lock or unlock different items so that the ... You need to traverse the CommandBar's Controls collection ...
    (microsoft.public.access.modulesdaovba)