expression that has no value error

  • Thread starter Thread starter Odewallrus
  • Start date Start date
O

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|
+----------------------------------------------------------------+
 
it would seem that the information cannot be found by the query. save the
record before running the query.
 
Back
Top