Searching a Table using a Form

[brag89]

I have a table called Contracts that includes fields called Company Name, Equipment Type.

I would like to set up a form that would allow me to search table 'Contracts' using either of the two field names above. Then would allow me to scroll between the records found

Help please as I am quite new to Access

 

[Jack Cowley]

I would suggest a form with the two combo boxes on it and a command button. Make a selection from one or both combo boxes and then clicking the button will open the form with the records you selected. The attached article will look intimidating but once you sort it out is a good way to do what you want where you are selecting data from more than one field in a table and want to show the selected records.

Query by form using QueryDefs

hth,
Jack