lock record so no changes can be made

[angie]

I have a combo box that when I select a entry in it I would like it to lock the current record.



I tried the following code.

after up date

me.comboboxname.locked = not me.new record

this works but it only locks the one combo box and I would like it to lock the record so no changes can be made.

Thank You

[Micron]

You mean after the selection has been updated to the record? Is the combo bound?
If not, I don't see the point in locking a record after making a combo selection.

And locking a record isn't the same thing as locking controls, which is what you seem to be wanting.

[pbaldy]

Locking the record (form) would be done by toggling

Me.AllowEdits

and perhaps also the deletions:

Me.AllowDeletions

[angie]

If the combo selection is " Excepted" than I would like to make it so that no changes can be made to the record.

[pbaldy]

So the test would be:

If Me.ComboName = "Expected" Then

or with Boolean logic

Me.Whatever = Me.ComboName = "Expected"

[angie]

not sure what you want me to do

[pbaldy]

Put 2 and 2 together.

Me.AllowEdits = Not Me.ComboName = "Expected"

[Micron]

So what if the control isn't bound? Then it has no value when the form opens.
I asked a few questions - no answers, so respectfully - you can take it from here. No hard feelings.

[angie]

Put 2 and 2 together.

Me.AllowEdits = Not Me.ComboName = "Expected"

Do I put this in the form property?

[pbaldy]

Well, you could start with where you had the other code. In general, I'd probably have it in the current event to handle changing records and in the after update event of the combo.

[angie]

Well, you could start with where you had the other code. In general, I'd probably have it in the current event to handle changing records and in the after update event of the combo.

i put it in the event for the combo box. But it did not work still can edit record.

[pbaldy]

Can you attach the db here?

[ArviLaanemets]

It's unclear what you really want!

Having a checkbox p.e. chkLocked linked to field Locked can be used to lock current record. For this you AllowEdits and AllowDeletions properties of in AfterUpdate event of chkLocked, and also in Current event of form (when for current record chkLocked, then no edits. Easiest way to allow edits for new record is set default value for chkLocked as FALSE. NB! As editing of record will be restricted, you cant unlock the record.

Having a unbound checkbox to disable entries/changes allows you to restrict edits and deletions in form, or allow them. Once the selection is made, it remains until it is changed again by new selection, or by Current event (which you also must have again) after selecting new record, when you designed it in this way. You can make the design so, that only new records are editable by default, and you can also enable the form to be editable record-wise.

For both ways, I advice also disable/enable or lock/unlock all controls linked to source data depending on status of field Locked, or of control chkLocked.

[angie]

What I would like to do is lock the record for being changed. If I had a unbound check box would that lock all records from being changed or just the record selected?
what code would I just in the unbound check box?
thank you for your help beyond by knowledge

[orange]

Can you post a copy of the database with enough info to highlight the issue?