forms

  • Thread starter Thread starter C
  • Start date Start date
C

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
 
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
Click to expand...

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
 
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
 
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
Click to expand...

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!)
 
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!)


.
Click to expand...
 
Back
Top