Custom LOV (List of value) form problem.

[yameen2011]

Hi,
i am working on accounting database in access2007,
i have created a continuesly form (LOV_GL30) based on a query (LOV_GL30),
the purpose of this form to provide value for a field on another form (GL30),
basicaly i am using this form (LOV_GL30) as a custom LOV (list of values) for form (GL30),
everthing is going good,but here i want to add a filter on a form to find a specific value on (LOV_GL30)
that when i enter a GL_Code in "FIND" field then my (LOV_GL30) only display that value, and if i enter GL_CODE only starting 3 or 4 digit than my form show me only a series of that GL_CODe
i have attached a sample of a database, and a screenshot that displaying my requirments.:banghead:
NOte: I have already using a Combobox for that purpose but that not fulfil my needs, thats why here i want to use a textbox for this purpose.

 

[madefemere]

Hello,

Like the attached file ?

Have a good continuation

 

[yameen2011]

Thank you very much , for your kind help. thanks alot.