Hi,
I have four fields that take part in a lookup that fills a table. There's a fifth one that is a dropdown that has three options, "Add", "Delete" and "Change" and a sixth one which is also a drop down of values "New" and "Old". When you fill the six fields and press the lookup, data is filled into the table and you can either change it or delete a row or add more rows. There are two challenges am facing
1) To disable the add row button when the drop down choice is not Add
2) There is a certain combination of two when you choose a combination of the fifth and sixth fields, e.g. "Old" and "Add", I want to disable the Autofill button or hide it. Thanks
Mark