Reading values from tables

[tweety]

Thanks for the the tip of hidding it from the list, didnt think of that. is this the best way to do it?



thanks again

[Bob Fitz]

Thanks for the the tip of hidding it from the list, didnt think of that. is this the best way to do it?

IMHO? Yes, but thats only my opinion.

[tweety]

Thanks for for all your help

[tweety]

i have applied all the rules and settings from your version of the database to mine, its all working fine but after adding a product i have to refresh the form for access to work out all the buying, selling and profit values. is there a way to make it work faster of deduce the delay?

[Bob Fitz]

i have applied all the rules and settings from your version of the database to mine, its all working fine but after adding a product i have to refresh the form for access to work out all the buying, selling and profit values. is there a way to make it work faster of deduce the delay?

Try
Me.Recalc
in the subforms AfterUpdate event. If you have totals shown on the main form, you may need to use
Parent.Recalc
either instead or after Me.Recalc as well.