How do I create a search that yields results from a table.

[lccrews]

I have no idea what I'm doing. I have a table with formulas for supplements. Field1 has the end item, field2 has the ingredient. I want to create a search box that, when I type in a value, searches field2 and returns the different items in field1 that it is associated.

Field 1	Field2
Magnesium	110021
Magnesium	110054
Magnesium	110288
Magnesium	110283
Vitamin C	110021

Search: 110021 Result 1: Used In: Magnesium, Vitamin C

[CJ_London]

1. create a continuous form with a recordsource of 'myTable' (whatever you have called your table) to display the results you want
2. in the header section create an unbound text box control called say txtSearch
3. in the header section create a button called say btnFind
4. in the click event of btnFind put the following code - change Field2 to whatever you are calling it in the table.

me.filter="[Field2] =" & txtSearch
'if Field2 is a text field and not a numeric field then use this instead
'me.filter="[Field2] ='" & txtSearch & "'"
me.filteron=true

5. open the form and type 110021 in your txtSearch control
6. click the button. Your form should refresh to just show the ingredients associated with 110021

[lccrews]

Thank you for the help Ajax!