automatic deleting without closing and reopening ms access

[damola]

Good day sir/ma
Am using northwind database 2007
Please Is it possible to delete items in order details and it reflecting immediately in the inventory without having to close and re-open ms access
Thanks

 

[John W. Vinson]

Good day sir/ma
Am using northwind database 2007
Please Is it possible to delete items in order details and it reflecting immediately in the inventory without having to close and re-open ms access
Thanks

Yes. If you delete a record, it's deleted immediately (and irrevokably, there
is no "undelete").

You might need to Requery some other control to reflect the change in table
contents; the F9 key will do so if the relevant form is open.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com