Find as you type: Limit List

[michael.legge@rbc.com]

Hi I have been implementing Allen Browne's find as you type module, I have provided the link below. I am using the on load VBA [on Event] statement " Call FindAsUTypeLoad(Me)" instead of the property "=FindAsUTypeLoad([Form])" He provides a method to suppress fields in the combo box as follows " =FindAsUTypeLoad([Form], "Combo1", "Text99")". I was wondering if there was any way to apply the same suppress methodology to my VBA on load code that would effectively do the same thing and limit the results in my combo box.



Any suggestions would be greatly appreciated

Thanks
Michael

http://allenbrowne.com/appfindasutype.html

[ssanfu]

I haven't tried the code, but it looks like "Call FindAsUTypeLoad(Me, "Combo1", "Text99")"

should function the same as "=FindAsUTypeLoad([Form], "Combo1", "Text99")"