I am trying to figure out how to display an image on a form based on a list-box selection. I am only working with about 8 different images. I want to display an image of a cpu when "cpu" is selected, an image of a printer when "printer" is selected, etc. I created a table and embedded...
This works great:
=IIf([HasData],IIf([ESY MATH]="-1","Y") & IIf([ESY MATH]="",""))
This line just puts a Y if there is a -1 in the ESY MATH
field and nothing if there is not.
However, this does not work - I get the data type mismatch in criterial expression #3464...
#Error message when adding items with a 0 or -1.
I have fields that are generated with a checkbox which results in a -1 in the underlying table if it the box is checked and a 0 if it was checked at one time and then is unchecked. However, I cleared out all entries in some of the fields -...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.