Dear Hilmar,
Sorry for the delay in reply. I will definitely give it a try. Meanwhile, I tried designing the form for the lookup with listgox. This is what I did –
1.In the lookup form, I designed 1 listbox and 1 textbox.
2.I passed parameters to the form like field name or expression.
3.In the form activate method, I created a DO CASE structure. Based on the parameter passed, I created the SQL for the ROWSOURCE of the listbox.
4.Then I generated a common method where I passed parameters like rowsource, height, width etc. Then I assigned these parameters to the listbox. So, my listbox in done with the required fields from the master file.

Secondly, in the LOSTFOCUS event of the textbox, I restructured my SQL based on the user input for search and changed the ROWSOURCE property accordingly.
Then I fired listbox.REQUERY TO update the listbox based on user input for search.

Now, I am facing 2 problems.
How can I write an intelligent ON KEY LABEL command in my main form, which will pass the proper parameter from any textbox to this form?
How can I update the textbox in the calling form with the value selected from the lookup form?