deleting and updating items in the inventory in real time in ms access.

[damola]

Good day sir/ma
Please I have a sales order form with a combo box from inventory query. As I sell out items I want it deducted immediately and also if a customer doesn't want an item anymore, I want to be able to delete and it updating the inventory immediately
Thank you

[Access Developer]

Fields on Forms are automatically updated when you move off the Form to
another, or move from the main Form to a Subform Control (or vice versa),
or when you specifically cause them to be updated. The simplest way to
force an update of the Form's RecordSource is to execute the VBA code

Me.Dirty = False

An appropriate place to put this code is in the AfterUpdate event of the
Control that is updated when you sell or return the item, _not_ the
AfterUpdate event of the Form. Your description of the Form does not
provide sufficient detail for me to be more explicit... if your user only
selects a number of items of the particular type selected, then you may need
to do some calculations to update the stored quantity, before executing this
code to force the recoord to be updated.

MVP Allen Browne has excellent information on inventory applications at
http://allenbrowne.com/appinventory.html.

--
Larry Linson
Microsoft Office Access MVP
Co-Author, Microsoft Access Small Business Solutions, Wiley 2010

"damola" <damol...@yahoo.com> wrote in message
news:20123933...@terrranews.com...