Check if field contains only one filtered value

[jaryszek]

Hi,



I have split form where i am using multisearch texboxes.

One of this field is Status.
I want to check if within this field is only Status "Zakończono".
If there are more then one type of Status msgbox should show.

In example below there are Status "Zakończono" and status "Wyeksportowano" so msgbox should be shown.

How can i do this ?

Thank you,
Jacek

[jaryszek]

I was thinking about adding hidden text box and there after clicking magnifying glass the new textbox would be updated.

for example user will write "Zako" and new text box will be updated.
And somehow my code should check if "Zako" belongs to "Zakończono"...

Jacek

[jaryszek]

Problem solved.

You can use Dcount function and count values different then Status 'Zakonczono'
(where clause something like Status <> 'Zakończono')

Jacek