This is a bit strange, but forms arent my usual forte. I have spent days on this issue so hoping someone can help.
If my code starts a fresh form, it will then execute the layout event. However, if the code determines data for a date, it produces the userform correctly with previous data populated but the layout event does NOT fire (which means my class wont kick in which looks for changes in a text box).
Does anyone have any tips as to what it can be? The odd thing is the way it builds the userform is similar - it is just from either a data sheet if there is previous, or from inventory if "new" (it is a stockcount to be used on a touchscreen pc) and the counts set to 0.
I am quite pleased to have got this far with it, but I am out of ideas as to why the layout wont consistently trigger after the form is loaded.