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?

 

[Falcon88]

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.

the problem of requery and recalc is when user insert new record on the sub form it jumps to the first record on that subform ....