It is a brave ask...cause i searched all over and still cant come up with a solution.

I was thinking input parameters..but still havent got that to work fully yet.

I havent been able to create any codes for the button...

I do know a work around for the problem but it would be really great if I could find a way to do this still.

you seem to have the idea as to what i am trying to do. Its sort of like building a project in VB but in MS instead.

The thing is, how do i let the append stored procedure know that I am appending data FROM the form?