Quote Originally Posted by torachan View Post
I will have a look through the whole code in the next day or two, are you committed to that actual calendar (it is code heavy on tracking mouse position) - I had to stop the timer to enable me to view the calendar form in the VBA editor (which is unusual).
From your profile I see you are using MS 365 o.s. however what version of Excel are you using and is it 32 bit or 64 bit.
Thank you.
I'm using MS 365 32bit.
I'm currently trying to change to rego ID dropdown on the renewal form. To only show regos that are due within the next 3 months (example. Select values from vehicle table if new rego is not blank then if new rego within 3 else if rego expiry date is within 3 months. But then if private or business is selected then it also only returns the values where it meets both values.