Print the word "DONE" based on a related value in Form 1

[jsteff]

Very simple request....(i thought)

In the form is the field, STATUS. I creted a "label" field (TaskStat) to simply display the word DONE in the lower corner of the form.

So: IF the STATUS field=6 then print the word "DONE" in the label field (TaskStat). I want this to happen as the user clicks the "next screen" arrow provided by Access at the bottom of the screen.

In the field status, "Before Update", I entered:
IIF([FORMS]![MAIN]![STATUS]=6, [FORMS]![MAIN]![TaskStatDisp]='DONE','')

When I open the form and manipulate the STATUS field, it errors out referring to "invalid macro"

Help!!!

 

[jadams0173]

If Status=6 then
forms!Main!TaskStat="Done"
end if

Also you have

I creted a "label" field (TaskStat)

But then you use

[FORMS]![MAIN]![TaskStatDisp]='DONE'

Make sure you are useing the correct label name.

Just for my on sake...when does the status = 6? hth

 

[jsteff]

I added this code as you suggested:
Private Sub Status_BeforeUpdate(Cancel As Integer)
If Status = 6 Then
Forms!MAIN!TaskStatDisp = "DONE"
End If
End Sub

When I step through the field "Status", I get the error:
Run-time error "438"
Object doesn't support this property or method.

FYI: the object "Status" is a drop down box that takes the numeric value of "Status" and converts it to a descriptive term. For example if Status=6 then the word in the box is "DONE".

Any ideas????? thanks.

 

[jadams0173]

Try this:

Forms!MAIN!TaskStatDip.[b]Caption[/b]="DONE"

 

[jsteff]

That was it!!!!

thanks.