Checkboxes - Mulitple Values Problem

HCL Domino Domino Forum
1

Hi

Can anyone help with the following problem.

I have a checkbox field named ‘Status’. This field contains values : N, P/A, BF, A, P, TBN.

The above values may contain further values in the future which will be added by the user.

My problem is that in my QuerySave method on the form I would like the user to assign a date to the ‘Reply Date’ field anytime the ‘status’ field contains the value ‘BF’.

This has to be in LotusScript.

I tried the following but it doesn’t take into account the situation of if more then 1 value is selected when ‘BF’ is selected.

Can anyone help please?

If source.fieldgettext("Status") = "BF" Then

	If continue <> False And source.fieldgettext("Status") = "BF" And source.fieldgettext("ReplyDate") = "" Then

		continue = False

		Messagebox "As this case has 'BF' status, you must enter a date by which a reply is expected.", 16, "Expected Reply Date"

		Call source.gotofield("ReplyDate")

	End If

End If
2

Subject: RE: Checkboxes - Mulitple Values Problem

Try this:

dim doc as NotesDocument

dim item as NotesItem

dim flag as Boolean

set doc = Source.Document

set item = doc.GetFirstItem ( “Status” )

flag = false

forall v in item.Values

if v = “BF” then flag = true

end forall

if flag and Source.GetFieldText ( “ReplyDate” ) = “” then

and so on

3

Subject: Checkboxes - Mulitple Values Problem - THANKS !`

Klaus

Works a treat.

Many Thanks

Mick