main form and continuous subform requery

[Falcon88]

hii dears

on main form a textbox ( txt2 ) to gives me the total of subform some field
how to requery that textbox ( txt2 ) after user add new item on the sub form without return to the first record on the subform ?

 

[theDBguy]

Try requerying the form's recordset intead.

Normally, I would use Recalc, instead of Requery, but I don't know what your code looks like. So, this is what I am saying above.

Me.Recordset.Requery

Hope that helps...

 

[Falcon88]

Try requerying the form's recordset intead.

Normally, I would use Recalc, instead of Requery, but I don't know what your code looks like. So, this is what I am saying above.

Me.Recordset.Requery

Hope that helps...

i try that code under the itemid after update , then under the subform after update but it didn't update the txt2 textbox .

 

[theDBguy]

i try that code under the itemid after update , then under the subform after update but it didn't update the txt2 textbox .

Like I said, you probably need to use Recalc, but I can't say for sure, since we can't see your form. Is txt2 bound to an expression? What is in its Control Source?

 

[Falcon88]

Like I said, you probably need to use Recalc, but I can't say for sure, since we can't see your form. Is txt2 bound to an expression? What is in its Control Source?

yes txt2 on the mainform , bound to an expression

 

[theDBguy]

yes txt2 on the mainform , bound to an expression

So, try Me.txt.Recalc instead.

 

[Falcon88]

So, try Me.txt.Recalc instead.

under which event ?

 

[theDBguy]

under which event ?

Under whichever event you were using Requery.

PS. Just make sure you reference the control properly, i.e. use the proper syntax.

 

[Falcon88]

Under whichever event you were using Requery.

PS. Just make sure you reference the control properly, i.e. use the proper syntax.

i try it , but it return to the firsr record on that sub form

 

[theDBguy]

i try it , but it return to the firsr record on that sub form

Did you remove the Requery part?

 

[Falcon88]

Did you remove the Requery part?

yes of course .

 

[Falcon88]

txtT2 textbox is bound to this expression :

=CLng(nz(DSum("PriceOFSer";"OrderDetailTbl";"OrderNo=" & [OrderID] & " AND TitleServi=" & 2);0))

 

[LarryE]

hii dears

on main form a textbox ( txt2 ) to gives me the total of subform some field
how to requery that textbox ( txt2 ) after user add new item on the sub form without return to the first record on the subform ?

Try:
Me.txt2.Form.Recalc

 

[theDBguy]

yes of course .

Which event are you using?

 

[Falcon88]

Try:
Me.txt2.Form.Recalc

plz understand me .
the txtT2 textbox is on the main form to gives me the total of a PriceService field on the subform .
what this code and under which event ?

 

[Falcon88]

wait , the subform is continuous , and i use keyboard arrows to move between its records , on that subfrm there combobox cboItemNo , i move to tha new record by using keybord arrows down to insert new record , when i use requery or recalc it jumps to the first record on that subform .

 

[Falcon88]

????

Help please

 

[theDBguy]

????

Help please

Can you post a sample db with test data?

 

[Falcon88]

Can you post a sample db with test data?

 

[Pat Hartman]

In the AfterUpdate event of the subform, you can recalc the main form control.

Unless you have a save button on the subform, the record you changed will not be updated until you move to a new subform record or back to the main form. That may be why you are not seeing the update immediately.