finding help

[Guest]

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

 

[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

Make it a continuous form?

Or set a criterium in the query for a report?

 

[Arvin Meyer]

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

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

 

[Rick Brandt]

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

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.