expression that has no value error

[Odewallrus]

I am trying to hide a subform based on a value within that subform. This
is working fine when selecting existing records, but fails when I try
to add a new record. The error states, “You have entered an expression
that has no value.” The value that I am checking is from a calculated
query. Attached is an example, if there is anyone that has resolved a
similar issue I would greatly appreciate a bit of assistance.


+----------------------------------------------------------------+
| Attachment filename: test.zip |
|Download attachment: http://www.MSAccessForum.com.com/forums/attachment.php?postid=130184|
+----------------------------------------------------------------+

 

[William Taylor]

it would seem that the information cannot be found by the query. save the
record before running the query.