forms

[C]

Please help!

I have two fields in a subform. I will like the first
field to have an entry called "completed" before the
second field can be enabled.

Thank you in advance

 

[John Vinson]

Please help!

I have two fields in a subform. I will like the first
field to have an entry called "completed" before the
second field can be enabled.

Thank you in advance

One way you can do this is to set the Enabled property of the second
control to False; also, in the (sub) Form's Current event, check the
value of the first field and set the Enabled property of the second
control to False (or to True, if the first field is "Completed").

Also you'll need code in the first control's AfterUpdate event like

Private Sub FirstControl_AfterUpdate()
Me!SecondControl.Enabled = (Me!FirstControl = "Completed")
End Sub

 

[c]

Thanks for your help, I tried it but keep getting an error
that says the "expression AfterUpdate you entered as the
event property setting produced the following errors:"
ReviewStatus_AfterUpdate

 

[John Vinson]

Thanks for your help, I tried it but keep getting an error
that says the "expression AfterUpdate you entered as the
event property setting produced the following errors:"
ReviewStatus_AfterUpdate

Please copy and paste your actual code; the names of the relevant
controls; and the actual error message (ReviewStatus_AfterUpdate is
the name of a routine, not an error message!)

 

[C]

Thank you very much, it worked

-----Original Message-----


Please copy and paste your actual code; the names of the relevant
controls; and the actual error message (ReviewStatus_AfterUpdate is
the name of a routine, not an error message!)


.