Pass a value from a query to a form

[cwwaicw311]

This database would be use by a the 4 user which i have already create in the Operator Table.



It wont be a problem to post it on Monday. Thank for helping me to solved the problem i faced doing this database...

[cwwaicw311]

Hi,

I try to follow the sample u send to me last week. But although for the main menu form i follow exactly, the combo box value for my form is the InventoryID while urs value is the InventoryName. I follow ur row source, but it just not the same... How do u make it to display InventoryName rather than display InventoryID...

This problem also occur on my Operator combo box in the Tracking table form...

[maximus]

is it a new from that your are trying to build or is one of the two forms that I saw in your previous post.

[maximus]

Observe carefully This is a query underlying a combobox. Row Sorce is the Table Machine_Inventory_Table. Now Machine_Inventory_Table saves only MachineID and IventoryID So to Display Machine Name I include Machine Table and place Machine Name From Machine Table in the Query.


Please see the attached screen shot

[cwwaicw311]

Yup, i just see the difference...

Regarding the prompting of minimun balance on the main menu is it ok...??

[maximus]

Yes I have already done it a couple of more tests and then I will post. within today. Remember Using Text(strings0 as primay key is never advised. Relational Concept of Database should always be followed while designing a database.

[cwwaicw311]

hi,

It quite late here, you do not have to rush on my post and i will only be checking next morning. So, I would like to thank you advance for all the help u give me....

[maximus]

Well as promised here is your mdb with minimum stock prompt.
Changes made:
1)Field Re-order level in inventory Table
2)Tag Field in Inventory_Tracking Table.

When you stock becomes = to < then re-order level on a particular transaction that transaction is taged and when you select the inventory in the main menu the transaction information is displayed. This will continue till your stock is less then or equal to re-order level. But as soon as the stock goes up and you select the inventory the taged trasaction is released.


I was following your post you wanted to know how to do a running sum. well i have used a query which does the same. now think about adding a danger stock level which should be lower then re-order level and once it reaches that level an user cannot make an more issue of that inventory.

let me know about your progress.