Re: 1,000 records to search

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I don't have a sample download (yet) for the search form.

However, I do use a bit of code. Assuming you have tryed the first 3
suggestions (none of which requite you to write code), then you can try my
last suggestion.

Build a unbound form. Place a text box near the top. Lets call the control
txtLastName. Turn just about everything off for this form (record selector,
navigation buttons etc). This form is NOT attached to a table, nor any data
(we call this a un-bound form).

In addition to the above, you an build nice continues form that displays the
columns of data in a nice list. you can then put this form as a sub-form
into the above form.

Then, in the txtLastName after update event you simply stuff the results
sql "search" into that sub-form.


dim strSql as string


strSql = "select * from tblCustomer where
LastName like '" & me.txtLastName & "*'"


me.MySubFormname.Form.RecordSource = strSql.


That is all there is to to the above...


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@xxxxxxx
http://www.members.shaw.ca/AlbertKallal


.

Quantcast