Help with Creating a Lookup

Good Morning,

I created a database in Access 2000 that contains the following fields:

Lot Number*
Work Order Number*
PO Number*
Requested Date
PO Date
Community*
Description
Amount
Matched

What I am trying to create is a lookup prompt that would allow me to key in one of the above fields (*) and all of the records with the item will be listed. If I have to create four different buttons for my switch oard, that would also be ok.

Thanks in advance for your help. I am new to Access and only know the very basics.

I would use combo box where I can select the value and search for the record on the form that matches the value I selected from the combo.

Eg. for Lot Number:

Dim RS As Object
Set RS = Me.Recordset.Clone
RS.FindFirst "[LotNumber] = " & Me![MyComboBox]
If Not RS.EOF Then Me.Bookmark = RS.Bookmark

where [LotNumber] is the control holding Lot Number and [MyComboBox] is the combo box where you select the Lot Number.