Text box in a Continuos Form

dbalargin

Member
Local time
Yesterday, 22:20
Joined
Dec 31, 2002
Messages
39
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.
 
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.
 
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
 
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
 

Users who are viewing this thread

Back
Top Bottom