Search results

Hi, Thanks for helping, I have tried but doesnot work, Same error for other field which is required in table properties. If I remove this as required then all these work pls note these I all applying in after update event of sprice in Salessubform in SalesM master forum

How I can so when subform field change and requery at footer

Pls open SalesM form and enter new record in subform It will not allow to do so because of required field

Ok I will update with database

Moreover if there is no other required fields the error does not come.

Dsum I have done in parent form footer to get the totals of records in sub form. And me.recalc put in afterupdate of field which totals I need in main form footer

Is there anyother way

Thanks for help Yes same Error

Hi all, I have a parent form with subform Subform fields summed with the help of Dsum at parent footer. I have put me.recalc in afterupdate of field. But when I run the form it gives error runtime 3314 for the other required fields. If I make field required to no there is no...

Thanks for your help Infact when I visit to download file there was no link, but I found a solution by count function

Have you got my point?.

Just like you buy something from store all items are like 1, 2,3 etc. When there is new invoice they make there is once again sequence 1,2,3...

In my example serialno meant to itemserial no which is suppose to autonumber and with each invoice reset to 1

Yes I meant to item serial no

Thanks for helping. For Each Invoice i want the Item serial number to be 1. for example Invoice no . 1 (master form) invoice details subform serial no Product Quantity Price Total 1 Apple 1 2 2 2...

It should back to 1

Pls refer to link. I made sale invoice. The itemserial no I want to be reset every time make new invoice https://www.dropbox.com/s/9jzhwzu1o9xdxn6/Sample.accdb?dl=0

Its a number. User will not put anything in it. It should be like autonumber

It is not primary key. Its just a line number and I want it to reset at every new record

You can say like line number