finding help

C

Caleb

Is there any way to have search for a record in the form, but instead of
having just one record show at a time, all the records that meat the searchs
criteria show in a text box or a list box? Thanks in advance
 
D

Dodo

Is there any way to have search for a record in the form, but instead
of having just one record show at a time, all the records that meat
the searchs criteria show in a text box or a list box? Thanks in
advance
Click to expand...

Make it a continuous form?

Or set a criterium in the query for a report?
 
A

Arvin Meyer

Caleb said:
Is there any way to have search for a record in the form, but instead of
having just one record show at a time, all the records that meat the searchs
criteria show in a text box or a list box? Thanks in advance
Click to expand...

Yes, I'd use a subform if you want to edit, or a list box if you don't. Set
the Recordsource (for the subform) or the Rowsource (for the listbox) to a
Select statement that returns just the reords you want. Something like air
code:

Sub cmdSearch_Click()

Me.lstWhatever.Rowsource = "Select * From MyTable Where CompanyID =" &
Me.cboCompanyPickList

End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
R

Rick Brandt

Caleb said:
Is there any way to have search for a record in the form, but instead
of having just one record show at a time, all the records that meat
the searchs criteria show in a text box or a list box? Thanks in
advance
Click to expand...

Apply a filter instead of using the "Find" tool. The Find tool is really
pretty horrible anyway from a performance standpoint. If you apply a filter
then you get all of the records that match the file at one time and it is
also more efficient.
 
Top