Display Inventory level when working with order detail subform??

[kelvin2088]

hi experts,

great to have such a nice place as mrexcel.

i'm working on a subform of a order form.

the main form, order form, obviously consists order info such as customer, date, etc.

the subform consists product name, price, qty and stuff.

is there anyway that i can also include corresponding "available inventory level" in the subform right next to qty? also, is there anyway to have it requery whenever i change the qty?

i actually wrote a query and inplanted it as a subform, however, it won't allow me to edit, delete or add...only read.......

 

[d_profesor]

i believe that is possible. may be you should try with add new unbound textbox into your subform. write the code to get for qty level ..

 

[kelvin2088]

i believe that is possible. may be you should try with add new unbound textbox into your subform. write the code to get for qty level ..

i tried...but my code is rubbish....
any sample code?

 

[d_profesor]

try this in ur textbox controlsource:

=dlookup("[Your level inventori field]","[YourqryInvLevel]","[Your ID Produk in query]=" & yourcontrolidprodukinsubform)

 

[kelvin2088]

try this in ur textbox controlsource:

=dlookup("[Your level inventori field]","[YourqryInvLevel]","[Your ID Produk in query]=" & yourcontrolidprodukinsubform)

thank you very much!

I'll try the code tomorrow when i get back to work.

 

[kelvin2088]

try this in ur textbox controlsource:

=dlookup("[Your level inventori field]","[YourqryInvLevel]","[Your ID Produk in query]=" & yourcontrolidprodukinsubform)

I tried and it worked when I only opened the subform.(not together with main form)

When I open the main form, the inventory part of the colum shows "#Error" and keep on flashing.
And sometimes it works by showing correct number.....what's going on?

I'm using Acc2003

 

[d_profesor]

I tried and it worked when I only opened the subform.(not together with main form)

When I open the main form, the inventory part of the colum shows "#Error" and keep on flashing.
And sometimes it works by showing correct number.....what's going on?

I'm using Acc2003

It's work here when i use that function in northwind database. the only error that i found is when id produk has null value. But sometimes the error like that happen when you have large enough data to process...it also depend on the query and index in the table that related in your inventory level query..

btw please attach your sample work here, so i can see it..