Inventory Issue (Suggestions?)

[klynch0803]

I have two tables 1 that is inventory Recieved and 1 that is inventory Used.

I runa query on actual inventory by subtracting used form received. This works fine.

What I want to do is show this on a form or report where I can enter the actual inventory beside each record and then be able to save it so that I can save it like this..

[Date] [Current Inventory] [Actual Inventory (manually entered by user)].

I tried making a Multiple items Form with the query I have and then adding a text box beside it so the user could enter the acual inventory in the text box and then add a save button to save the levels to a table. Problem is if you enter a value in the text box it adds the same value to all the texts boxes on the form nstead of just that one line..

What can I do or how can I fix this?

 

[Rabbie]

There have been a lot of threads about Inventory issues. Try searching the forums for "Inventories"

 

[klynch0803]

There have been a lot of threads about Inventory issues. Try searching the forums for "Inventories"

I have done this and see some things similiar but no real solutions that is why I posted this thread. Thanks for the suggestion though...

 

[klynch0803]

Ajetrupmet,

Here is the file for your review and help.

The form is "fdatInventoryCheckup" and can be found by clicking "Purchases Sales Menu" and "Inventory Checkups" or in the Forms list whichever way you rather.

Problem 1:

If you enter the actaul level you will notice it fills all fields with same value instead of just the one you typed into.

Problem 2:

If you save it only saves the first record not all of them.

Thanks for your help...