I have a variable that is assigned a value from one of my subforms. It is a percent. In the subform the text box that calculates the value is formatted for percent. When I assign the value to my variable I get the "Type mismatch" error. I am completely stumped. Any tips as to where I can look? I set up my variable the following ways and neither worked
Code:
dim varPctColl as double 'Tried this way, did not work
dim varPctColl 'Also tried this way, did not work
varPctColl = Form_SfrmCollections.txtPrctBal.value