Update Inventory in Subform

[Kevo]

Hi,

What I would like to do is Choose an "assembly" from a combobox and have the subform open up the list of instruments in the assembly.


Then have 2 textboxes below with "QtyUsed" & "QtyReceived" and a button for "update inventory".....

On click event for the button it will update QtyOnHand in list of subform.

Something like "QtyOnHand = QtyOnHand - QtyUsed + QtyReceived"

Can this be done? I have tried several ways but not quite getting it.

Do you make the subform a combobox so when you choose a record it has focus? Or is their a way to show the whole list of records (datasheet view) and still be able to update particular record with buttons below?

Hope my question is clear.

Thanks,
Kevin

[Robeen]

You can do your calculation for Quantity and then set the value of the QtyOnHand control on the subForm to Quantity:
Forms!YourFormName.Controls!QtyOnHand = Quantity
Have you tried something like that already?