Hello,
I am trying to create a form where the user can browse through the different clients. This form also has an excel spreadsheet inside of it which allows the user to search for the correct client, then input data into the specific columns. These columns in turn save the data to a single table that all the data of that sort go into. The form pulls certain rows out of the table based on the client ID#, which is one column in the table. This is how the form tells which certain rows to show when the certain client is accessed.

I have already designed the form and the subform that goes into it, which is where the spreadsheet lies. I've also created a sample table with some real client ID#'s and info that should pop up when the table is accessed. I can't link the information, get the form to show the specific client data, or get it to store new records in the exisiting table based on the input to the spreadsheet. Please help me with this. Any clues and advice would be much appreciated.