Please any help appreciated!

[ChrisBeach]

I have an access 2k3 front end linked to a SQL Server 2k backend and
have been having quite the issue with deleting.. I have a form with a
subform, in datasheet view.. there are 2 combo boxes both of which are
master links to the sub datasheet, now when I select a plant and a
date, it brings up all the correct records, but my problem is, if i try
deleting a row from the datasheet it deletes it. but then adds the
topmost record from my table in the database and changes the date to be
the same as the rest in the datasheet. This _seems_ to only happen if I
delete a row at the bottom of my datasheet. Any insight into why this
is happening is greatly appreciated, thanks!

 

[SammyTBlue]

If I understand, as a result of deleting the bottom record from the subdatasheet, it is adding the 'first' record from a primary table into the subdatasheet?

Is it truly adding the entire record, or is it only the date field that is filled...if so, could it be a default value on the date field giving the illusion of an added record?

 

[ChrisBeach]

Thank you for taking the time to reply

Yes, it's truely taking a record.. its not default fields, it grabs a record from the next date segment (it seems.. ive been testing awhile now) so if I have

1/1/2005 Plant2
1/1/2005 Plant2
10/10/2005 Plant1
10/10/2005 Plant1
10/10/2005 Plant1

My program shows all of the 10/10/2005 fields when you select that date from a combo box and plant1 from the other combo box. Now If I delete the last 10/10/2005 record it seems to pull the next record above that group of dates (1/1/2005 Plant1) and changes the date and plant to fit in with the 10/10/2005 Plant1 set...Really confusing and weird