VBA changes on existing form

Hi Sabrina

Sorry for not getting back sooner.

I've had a look at your form today. The reason you are getting the error "compile error method or data member not found" on the Allowance Form A is because the code is referencing Textbox7. This doesn't exist and I think is the Reason for Allowance box added to the Business centre rev file.

So in the Allowance Form A workbook you need to remove any reference to Textbox7, for example Or Me.textbox7 = "".
Also comment out the procedure Textbox7_change()


To find a control such as Textbox7 -
In the vb editor
Double click on Userform1
In the Properties window click the drop down to view all controls

Then whichever one you click becomes selected on the form.

Hope that helps for the moment.


Regards
Doug Dunn
Best STL