Can you just tell us again what you are trying to do?
You have an Access front end that will be/is talking to Sql Server backend.
Please expand on this:
I need to create just one blank row for the user to fill out and submit
You are trying to add a record to the BackEnd?
What exactly is the purpose of the Blank row?
If you access a table, without constraints, you will have access to the whole table.
In other words, you get what you ask for. If you want John Doe's record, you would have code along this line
Code:
select * from EmployeeTable
Where EmployeeFirstName = "John" AND
EmployeeLastName = "Doe"