I have a form with a PackType and a PackQty input box. I want the boxes to update fields in a table called Packaging. My PackTypes field includes Reel, Tube and Single. The problem is that sometimes values for reel and tube can vary. Any suggestions on what I'm not doing right here? Thanks.
http://c.imagehost.org/0447/Access1.jpg
http://c.imagehost.org/0447/Access1.jpg