Hi all,
Question re an order input database (I set up years ago) that I'm having to make more user friendly for others.
I have a form that allows selection of a customer and a delivery run with a subform to select products and enter amounts etc.
To make it more user friendly I'm trying to use an unbound combo box with a row source that points to a table with product types (could do it on the product type field in the product table itself but just get the ID rather than the product type name.
In the subform all seems to work fine but when accessed through the main form I get an Enter parameter value? box.
Been chasing my tail trying to figure out how to make it work but could do with some help if anyone has any ideas...
Question re an order input database (I set up years ago) that I'm having to make more user friendly for others.
I have a form that allows selection of a customer and a delivery run with a subform to select products and enter amounts etc.
To make it more user friendly I'm trying to use an unbound combo box with a row source that points to a table with product types (could do it on the product type field in the product table itself but just get the ID rather than the product type name.
In the subform all seems to work fine but when accessed through the main form I get an Enter parameter value? box.
Been chasing my tail trying to figure out how to make it work but could do with some help if anyone has any ideas...