first of all I seem to be having a little difficutly in recording a macro to
just open a form to input database information on the row under the labels of
each column.
I know I can just open form after highlighting the row of labels and put the
information in that way. But I want a button on the spreadsheet to click onto
to open the form to input the data, and a button to do a search in the same
fashion.

My first problem is getting the macro to record properly.
Second will be to get the command button to run the macro.
I think I can do the second part of this but need the macro to do it.