Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

lock record using conditional formating

Discussion in 'Information Technology' started by Bessie, Nov 3, 2005.

  1. Bessie

    Bessie
    Expand Collapse
    Guest

    Hello,

    How do you lock a record when using conditional formating? I am using
    conditional formating on the primary auto number when i close the record the
    number change to red. I also have a subform link to that record. I want to
    lock the record to prevent anyone from changing the billing number, how do i
    create a code for it?

    thank you
    Bessie
     
  2. Loading...

    Similar Threads Forum Date
    Debate With Sarbjeet Singh Dhunda At Turlock (California) Gurdwara, April 2015 - YouTube Gurmat Vichaar Apr 23, 2016
    Uk clocks go back Blogs Oct 17, 2015
    Kesh: Dreadlocks Questions and Answers Nov 20, 2013
    Obamacare Faces Near-Solid Block In The South Health & Nutrition Mar 31, 2013
    Malaysia Have you forsaken your flock, Archbishop? Malaysia News Update Breaking News Jan 30, 2013

  3. Ofer

    Ofer
    Expand Collapse
    Guest

    You need to use code to lock the fields or the sub form with the condition
    you are using in the conditional formating

    On the OnCurrent event of the form, add the code
    If [Enter here your Condition] then
    me.FieldName.Locked = True
    Me.SubFormName.Locked = True
    Else
    me.FieldName.Locked = True
    Me.SubFormName.Locked = True
    End if
    ================================
    Also if you update a field in the form, and depend on the value you entered,
    you want to lock the fields, then add the code above to the after update
    event of that field
    --
    If I answered your question, please mark it as an answer. That way, it will
    stay saved for a longer time, so other can benefit from it.

    Good luck



    "Bessie" wrote:

    > Hello,
    >
    > How do you lock a record when using conditional formating? I am using
    > conditional formating on the primary auto number when i close the record the
    > number change to red. I also have a subform link to that record. I want to
    > lock the record to prevent anyone from changing the billing number, how do i
    > create a code for it?
    >
    > thank you
    > Bessie
     

Share This Page