François Degrelle wrote:i use this code for two different kinds of user.
Show the code in your button.
François Degrelle wrote:i have 2 record group that i call from the above code
I don't see where you order the query in that code.
Andreas Weiden wrote:yes it is true. when i open this lov in my form it takes not enough time,i mean it's faster..it shows 30 thousand data(queried ALL records.) in the lov..
whereas when you open a LOV in forms, the query returns after having queried ALL records.
suppose PR.12.011577 is a code that i want to search from 30 thousand this type of codewhen i enter PR.12.01 to search the above code it shows busy sign for 10-12 sec in form 6i..