Hello,

I have just set up my first database in Access and I want to do 2 things that I am having trouble with.

1. I would like to create a search form, such that a user can enter in text and the result is a search through two tables that I’ve created: Chemicals and Source (They are linked: Source is a subform in Chemicals). The search would result in the “Chemicals” table that matches the search. If it is possible...