@Amboseli this was the point I was making at the start of the post, but I don't think this was correct.
I am an actuary so familiar with setting assumptions to calculate transfer values, but my experience is in private sector DB pensions and not public sector.
In private DB schemes, the transfer value assumptions are set by the actuary to be consistent with how the DB scheme invests the assets. Generally, the discount rate would be linked to bond prices (interest rates) because pension schemes tend to invest in bonds. The assumptions are then generally updated monthly, or sometimes less frequently like quarterly. If interest rates go up (all else being equal) the transfer value would then go down.
However, from the information others have given below about the LGPS, the assumptions don't seem to work like this. I have no experience of this but from looking at the links people have below, it looks like the discount rate is set in line with inflation and fixed for a longer time period. I'm assuming this approach reflects the fact that public sector schemes are generally unfunded and so this is a better estimate at the cost of providing the pension. If I've understood this correctly, this would explain why others have said your transfer figure won't change from month to month.
That's a long winded way of saying perhaps the IFA you spoke to was thinking of private sector transfer values rather than understanding the nuances of the LGPS, like I was doing at the outset.
My only other comment is to please be very careful if you do decide to transfer as there are unscrupulous products out there willing to "help" customers who can't find any other way to transfer. If in doubt, contact the Government's Pensions Wise service (the website is called Money Helper).