Hi

Hi MTB

No, what I mean is, the staff are usually issued with these items from the store, so whenever any item is given out, then the current quantity should drop by that number so as to reflect the correct figure, right? This is the figure displayed in the balance textbox. The only problem is, the balance is calculated well, all right, but how can i now reflect this value in the current quantity textbox, so that when...

I'm trying to calculate the quantity of stock in an organization. I have a text box to reflect the current quantity, another for the no. issued to staff, and another to show the remaining balance. However, when any of these is used, the balance reflected is correct, but the quantity stays the same when i select the same product later. How can i update this quantity so that the stock level reflects correctly? Should i have another form specifically...

Thanks

Thanks for your help, it worked out fine.

Hi

I'm trying to add a new record to a subform called itemsreceived_s ubform, using a command button. I can't get the clear difference between the subform control, and the subform itself. My code is as follows:

Private Sub cmdadd_Click()
If Me!Itemsreceive d_subform.Form. Dirty Then
Me!Itemsreceive d_subform.Form. Dirty = False
End If

Me![Itemsreceived subform].SetFocus ' This...