AutoNumber line showing up on bottom of form.

[needadvice]

I have a form that pulls up a set of records (based on a SSN) for editing.
It works ok, but the bottom record appears to be the autonumber line from the table. All the fields are blank.
I have no use for this on the screen and would like get rid of it.
Any ideas?

 

[TimmyNF]

I think the problem you are having is with the EOFAction of the Datasource. When you get to the last recordset of your database its action is to create a new record. That is why you recieve an autonumber and all the other fields are blank. Look at the "EOFAction" property of your recordsource. Is it set to "2-AddNew"? If it is, try setting it to "0-MoveLast".

-Tim

 

[needadvice]

Thanks Tim,
I will give that a try.

 

[MichaelRed]

Are you sure this is not the record navigation control?

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over