Updating Locked Fields

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

This is what I am attempting to do:

I have a field called [PayDenyReturn] which can hold
either a "P","D","R",or Null value. There is a
[PaidDate] field which must be populated if it is a P,
and a [DenyDate] field if it is denied or returned. To
keep people from entering in the date in the wrong box I
have it so that if [PayDenyReturn] = "P" then the
[DenyDate] field is not enabled, and for [PayDenyReturn]
= "D" the [PayDate] is not enabled. When [PayDenyReturn]
= Null both fields are not enabled.

Is there a way to be able to go from the null field with
both not enabled to entering a value in [PayDenyReturn]
and having only the one box not enabled without having to
leave the record to save it?

I have tried to refresh, repaint, and others on OnDirty,
OnUpdate, OnChange, etc... and nothing seems to work.

Any help would be GREAT!

I am using Access 2002.

-Michael
 
I have tried, still nothing.
Any other ideas?
Thanks for the help

Michael

-----Original Message-----
Use the AfterUpdate event of the PayDenyReturn control.

--
Ken Snell
<MS ACCESS MVP>

This is what I am attempting to do:

I have a field called [PayDenyReturn] which can hold
either a "P","D","R",or Null value. There is a
[PaidDate] field which must be populated if it is a P,
and a [DenyDate] field if it is denied or returned. To
keep people from entering in the date in the wrong box I
have it so that if [PayDenyReturn] = "P" then the
[DenyDate] field is not enabled, and for [PayDenyReturn]
= "D" the [PayDate] is not enabled. When [PayDenyReturn]
= Null both fields are not enabled.

Is there a way to be able to go from the null field with
both not enabled to entering a value in [PayDenyReturn]
and having only the one box not enabled without having to
leave the record to save it?

I have tried to refresh, repaint, and others on OnDirty,
OnUpdate, OnChange, etc... and nothing seems to work.

Any help would be GREAT!

I am using Access 2002.

-Michael
Click to expand...


.
Click to expand...
 
Tried it, still no luck!
Any other ideas?
Thanks for the help

-Michael

-----Original Message-----
Use the AfterUpdate event of the PayDenyReturn control.

--
Ken Snell
<MS ACCESS MVP>

This is what I am attempting to do:

I have a field called [PayDenyReturn] which can hold
either a "P","D","R",or Null value. There is a
[PaidDate] field which must be populated if it is a P,
and a [DenyDate] field if it is denied or returned. To
keep people from entering in the date in the wrong box I
have it so that if [PayDenyReturn] = "P" then the
[DenyDate] field is not enabled, and for [PayDenyReturn]
= "D" the [PayDate] is not enabled. When [PayDenyReturn]
= Null both fields are not enabled.

Is there a way to be able to go from the null field with
both not enabled to entering a value in [PayDenyReturn]
and having only the one box not enabled without having to
leave the record to save it?

I have tried to refresh, repaint, and others on OnDirty,
OnUpdate, OnChange, etc... and nothing seems to work.

Any help would be GREAT!

I am using Access 2002.

-Michael
Click to expand...


.
Click to expand...
 
Try this:

Private Sub PayDenyReturn_AfterUpdate()
Me.PayDate.Enabled = (Me.PayDenyReturn.Value = "P")
Me.DenyDate.Enabled = (Me.PayDenyReturn.Value = "R" Or
Me.PayDenyReturn.Value = "D")
End Sub


--
Ken Snell
<MS ACCESS MVP>

Michael said:
Tried it, still no luck!
Any other ideas?
Thanks for the help

-Michael

-----Original Message-----
Use the AfterUpdate event of the PayDenyReturn control.

--
Ken Snell
<MS ACCESS MVP>

This is what I am attempting to do:

I have a field called [PayDenyReturn] which can hold
either a "P","D","R",or Null value. There is a
[PaidDate] field which must be populated if it is a P,
and a [DenyDate] field if it is denied or returned. To
keep people from entering in the date in the wrong box I
have it so that if [PayDenyReturn] = "P" then the
[DenyDate] field is not enabled, and for [PayDenyReturn]
= "D" the [PayDate] is not enabled. When [PayDenyReturn]
= Null both fields are not enabled.

Is there a way to be able to go from the null field with
both not enabled to entering a value in [PayDenyReturn]
and having only the one box not enabled without having to
leave the record to save it?

I have tried to refresh, repaint, and others on OnDirty,
OnUpdate, OnChange, etc... and nothing seems to work.

Any help would be GREAT!

I am using Access 2002.

-Michael
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top