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!
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!