I have created a form that has a combo box and that combo box has VBA code that gets other fields to autofill but the problem is my combo box no longer auto expands as I type in in my case a book title into the combo box. I have narrowed the issue down to the price field it has something to do with the currency format.
If I remove it from the code and the auto expand works again and all field bar price autofill. the number format field doesn't cause any issues just the price.
I have tinkered further and I think it is to do more with the fact the price field is used in a calculated field sub total field [price]*[quantity].