[stewartrr]

Hi, and thanks for any help.

I am a newbie to VBA programming.

I am creating a worksheet of contacts and the date and time that I phone them, along with their current "status" in our company.

I have created a form and have got it o do the insert of new data that I input, BUT

What I would really like is enter a "client number" (which is unique) and have it search my table for any record(s) with that client number, and the show me the last record that matches the client number, (this can all be done from within my form) then

If I click on the "insert" command button, I want it to insert a new row after the current row and move my form data in the form into the new row which will include a date and time.

So,
To summarize.....
LOOKUP ----- I need to have my form scan down the data for a match in a particular (pre-sorted) column, stopping at the last line that matches, then display the data or dispay nothing is there is no match
INSERT ----- I need to have the form scan down the data for a match in a particular (pre-sorted) column, stopping at the last line that matchesinsert a blank row here and move my data into it.

Rob