I have two simple questions:
1) Force a control in the subform of mainform to recaculate:
I have a mainform named "products" and 04 subforms inside named:
"InventorySubform" subform of the table "Inventory summary"
"SubDelivery" subform of the table "delivery control"
"Stockout Subform" subform of the table "stockout"
"currentremainedSubform" form of the query "currentremained"
The "InventorySubform" subform have a coltrol named:"initialstock"
The "SubDelivery" subform have a coltrol named:"shiped"
The "Stockout Subform" subform have a coltrol named:"out"
The "currentremainedSubform" subform have a coltrol named:"remained"
The control "remained" is using the formula: =initialstock+shiped-out
They works exactly with no problem. But when I modified the value in
"InventorySubform" or in "Stockout Subform" or in "SubDelivery", they
don't recaculate immediately (i mean they don't recaculate with real-time effect)
I already tried ".requery" in the afterupdate event in those subform's controls like this:
Forms!products!currentremainedSubform.Form!Remained.requery
But above code don't work.
Could any one give me a trick on this issue?
2) Print diallog:
I always use the print command buttont wizard to create print button for access form.
If I press it, it give me the action of printing current record or all records.
But I want to use the print dialog of windows.
(I mean: for example, In microsoft word or excel, if you press ctrl+P, a print dialog of windows appear, I want to use it)
Could anyone give me a code to be able to use that print dialog in my form?
many thanks.
1) Force a control in the subform of mainform to recaculate:
I have a mainform named "products" and 04 subforms inside named:
"InventorySubform" subform of the table "Inventory summary"
"SubDelivery" subform of the table "delivery control"
"Stockout Subform" subform of the table "stockout"
"currentremainedSubform" form of the query "currentremained"
The "InventorySubform" subform have a coltrol named:"initialstock"
The "SubDelivery" subform have a coltrol named:"shiped"
The "Stockout Subform" subform have a coltrol named:"out"
The "currentremainedSubform" subform have a coltrol named:"remained"
The control "remained" is using the formula: =initialstock+shiped-out
They works exactly with no problem. But when I modified the value in
"InventorySubform" or in "Stockout Subform" or in "SubDelivery", they
don't recaculate immediately (i mean they don't recaculate with real-time effect)
I already tried ".requery" in the afterupdate event in those subform's controls like this:
Forms!products!currentremainedSubform.Form!Remained.requery
But above code don't work.
Could any one give me a trick on this issue?
2) Print diallog:
I always use the print command buttont wizard to create print button for access form.
If I press it, it give me the action of printing current record or all records.
But I want to use the print dialog of windows.
(I mean: for example, In microsoft word or excel, if you press ctrl+P, a print dialog of windows appear, I want to use it)
Could anyone give me a code to be able to use that print dialog in my form?
many thanks.
