Me.recalc error

[haroon.mansha]

Hi,

I have tried, still not working

 

[haroon.mansha]

My problem in simple words is :

If I make required fields to No in the table then me.recalc on afterupdate event working fine.

While if I make them required in the table then it doesnot works with the error requiring the field.

So inshort, some method which works me.recalc without poping error for required fields (which are next on the form)

 

[GinaWhipp]

I was suggesting you replace your DSum() statement with my Sun() statement, then add the previous Requery line to your field and it should work.

 

[haroon.mansha]

I did but it gives error for sum function as it suggest sum(expression) no criteria etc

 

[GinaWhipp]

Have a look at the one I attached...

 

[haroon.mansha]

Thanks for help, I have tried, But still the same error

Have you checkes SalesM entry and after Sprice update the footer should update, but it gives error of RateofSalestax required, (because it is required in table) May you have tested with existing entry as there is already all entries in records, nothing empty

 

[GinaWhipp]

Oh, yes, I did not test on a new record and in that case, yes, you do get an error. That would be one of the reasons I don't do validation at the Table Level. So, they way to avoid that is to move the Requery line to After_Update of the required field. Not sure that will work either but it's worth a try.