dataentry form preset to subtract quantities

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database to control date sensitive products. All is working well but
to speed up dataentry how do I "preset my quantity colunm" so that it is
always a minus quantity.

I would then be able to have an "Inputs" form adding to the quantity and
create another form to track "sales" by making every entry a negative
I can do this now with one form but every quantity requires an additional
keystroke of the "minus key" and sometimes you forget to minus and so add!
 
well, you could add code to the textbox control's AfterUpdate event, as

Me!MyControl = Me!MyControl - (Me!MyControl * 2)

but i'm not sure why this is an issue. to calculate current inventory, you
should be able to simply sum the "inputs" and the "sales", and subtract
sales from inputs, in a query or expression, as needed.

hth
 
Back
Top