| | |
|
|
|
Update Record |
|---|
| message from suzie on 6 May 2004 |
I want to disable one field (e.g Identification Number)
from being editing. When user has entered data and they
want to update the other field, the can do so..but when
they click at Update button, other field can be edited
except Identification Number. It remains unchanged
Form has 5 fields:
i. First Name
2. Last name
3. Identification Number
4. Address
5. Phone Number
other fields can be updated except Identification Number
TQ
|
| DebbieG replied to suzie on 6 May 2004 |
If this is on a form, you can change the following properties for that one
field: Locked = Yes, Enabled = No.
HTH,
Debbie
"suzie" <anonymous@discussions.microsoft.com> wrote in message
news:969501c433dc$65ac0310$a401280a@phx.gbl...
I want to disable one field (e.g Identification Number)
from being editing. When user has entered data and they
want to update the other field, the can do so..but when
they click at Update button, other field can be edited
except Identification Number. It remains unchanged
Form has 5 fields:
i. First Name
2. Last name
3. Identification Number
4. Address
5. Phone Number
other fields can be updated except Identification Number
TQ
|
| suzie replied to DebbieG on 6 May 2004 |
i tried this method, but when i want to enter a new data
the identification number field is locked.
e.g i have 4 records and I want to enter the next record
(record no 5)..i can enter all info except identification
number.
for existing record, it is working fine as i cannot edit
this field. but what about new data?
properties for that one
|
| DebbieG replied to suzie on 7 May 2004 |
Suzie,
Private Sub Form_Current()
If Me.NewRecord then
Me.YourID.Locked = False
Me.YourID.Enabled = True
Else
Me.YourID.Locked = False
Me.YourID.Enabled = True
End If
End Sub
Debbie
"suzie" <anonymous@discussions.microsoft.com> wrote in message
news:999c01c433e6$cbf51df0$a601280a@phx.gbl...
i tried this method, but when i want to enter a new data
the identification number field is locked.
e.g i have 4 records and I want to enter the next record
(record no 5)..i can enter all info except identification
number.
for existing record, it is working fine as i cannot edit
this field. but what about new data?
properties for that one
|
| DebbieG replied to DebbieG on 7 May 2004 |
In the On Current Event:
Private Sub Form_Current()
If Me.NewRecord then
Me.YourID.Locked = False
Me.YourID.Enabled = True
Else
Me.YourID.Locked = True
Me.YourID.Enabled = False
End If
End Sub
Debbie
"DebbieG" <debbieg@accessus-REMOVE-THIS-.net> wrote in message
news:e0tw2S$MEHA.740@TK2MSFTNGP12.phx.gbl...
Suzie,
In the On Current Event:
Private Sub Form_Current()
If Me.NewRecord then
Me.YourID.Locked = False
Me.YourID.Enabled = True
Else
Me.YourID.Locked = False
Me.YourID.Enabled = True
End If
End Sub
Debbie
"suzie" <anonymous@discussions.microsoft.com> wrote in message
news:999c01c433e6$cbf51df0$a601280a@phx.gbl...
i tried this method, but when i want to enter a new data
the identification number field is locked.
e.g i have 4 records and I want to enter the next record
(record no 5)..i can enter all info except identification
number.
for existing record, it is working fine as i cannot edit
this field. but what about new data?
properties for that one
|
|
Archived message: Update Record (MS Access Database)
