a sub who modify a record

[m.belaouchi]

hello
i have a continuous form where controls are locked.
my question is : can i create a button command who modify the active record in this form.
i mean something as we see in WinDev or other..
think you and sorry for my english

 

[John Big Booty]

Welcome to the forum.

to answer your question. yes you can and here's a small sample that demonstrates just that.

 

[m.belaouchi]

think for your reply
i think you pass near it, except one detail : the update record must be in the same form where are the records (not via pop up form).
to simplifie, i just ask for a sub who can unlock fields (or record) in the active form. (i dont want be forced to close and open it!)

 

[m.belaouchi]

considering that my form is under another form, i can temporary opening the same form two at the time (one with the locked fields and the other with unlocked fields) and masking or unmasking each other

 

[vbaInet]

1. Set the AllowEdits property of the form to False in the property sheet.
2. In the Click event of the button, set the AllowEdits property to True
3. In the On Current event of the form, set the AllowEdits property to False

 

[John Big Booty]

Given that the sub form is in continuous view, the OP will not be able to limit those properties to a specific record; will he?

 

[vbaInet]

If the button is in the subform in continuous view then when clicked it will allow all records to be editted, at which point the current record can be editted. But when you move off that record the On Current will disallow edits.

 

[John Big Booty]

Ah Yes, so it will, missed that small but vital point

 

[m.belaouchi]

i wish to Think you both Ms. for beeing concerned with my problem.
my hope is that i can reply equally and continuously in this forum (i like it!)
honesty is the best policy

 

[vbaInet]

We earnestly await your kind contributions