Cant get field value to show up.

[Guest_imported]

This works except for the proj_id wont give me the project id number when it has no records. The output on my form is:
"Project has no records"
It should be:
"Project 23 has no records" or whatever the project number is should appear where 23 is located.

It doesnt seem to acknowlege the [proj_id] part. Anyone with experience can tell me what I am doing wrong with this??


[tt]
=IIf(Count([proj_id])=0,"Project " & [proj_id] & " has no resources.","Record " & [Forms]![ProjResOM].[TEST2].[Form].[CurrentRecord] & " of " & Count(*))[/tt]

 

[BlackKnight]

Hi,

Is ProjID a field 'cause I believe after using the Count() and not finding any recs the record pointer will be sitting on an empty record with ProjID set to null. You may need to store ProjID in a textbox somewhere before the count() is done.

Have a good one!
BK