Text box in a Continuos Form

[dbalargin]

I have a continuos form with 7 seven text boxes.
The more records in the bound table, the more text boxes.
How do I unlock only the 7 text boxes that is the "current record".
I do not want the other boxes unlocked.

 

[Pat Hartman]

On a continuous form, only one record is current at any given time. Whether the textboxes are locked or unlocked on records other than the current one is irrelevant. When you move your cursor to a new record, that one becomes current.

 

[dbalargin]

I want to allow the user to make changes in one row of boxes and not in any other rows.
How do I unlock one row of boxes without unlocking the other rows of boxes

 

[Pat Hartman]

You can't. Access maintains a single set of properties for a form. It does not maintain a set for each record. Therefore, the properties are for only the CURRENT record.

If you have some field in a record that you can use to determine if you want controls to be locked or unlocked, you can set the property in the Current event of the form.

If something Then
Me.fld1.Locked = Yes
Me.fld2.Locked = Yes
Else
Me.fld1.Locked = No
Me.fld2.Locked = No
End If