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

i have no idea i'm doing. have table formulas supplements. field1 has end item, field2 has ingredient. want create search box that, when type in value, searches field2 , returns different items in field1 associated. 

field 1	field2
magnesium	110021
magnesium	110054
magnesium	110288
magnesium	110283
vitamin c	110021

search: 110021         result 1: used in: magnesium, vitamin c                  

create form unbound combobox. set rowsource of comeobox to:

select distinct field2 table order field2;

create query table:

select field1, field2 table fields2 = forms!formname!controlname;

where formname name of form , controlname name of combobox.

then create report based on query, add button on form run report. 

select ingredient press button , report show end items using ingredient.

Office / Access / Windows 10 / Office 2016