Search field Vs Drop Downs

[LC]

Hi,

I have a huge problem. I'm told to create a form that
have drop downs which contains over 200+ items. I do not
think this will be suitable.

I have thoughts on creating a form A in which when the
textbox field is activated another form B will pop-up.
This form B will be like a search form in which the user
must fill in desired values to search. When those values
are populated a search result will appear on a subform
which is simply a spreadsheet form. Will the user double
clicks a row on the spreadsheet, form B will close and
the textbox field on form A will be populated will that
particular value.

Is this possible?
If so, is there a sample database/ form that I can see.
OR how would I do this?

Thank you so much,
LC

 

[Albert D. Kallal]

Take a look at the following screen:

http://www.attcanada.net/~kallal.msn/Search/index.html


So, I simply put some code in the after update event

dim strsql as string

strsql = "select * from tblCustomers where Lastname like '" & me!textSearch
& "*'"

me.MySubForm.Form.RecordSouce = strSql

There is also a sample search form here that might give you some ideas:

http://www.datastrat.com/DataStrat2.html

And some more ideas here:

http://www.mvps.org/access/forms/frm0045.htm