change data form other

[Balen]

Hi I have item and total item i want when i sale 2 item the total item automatically mines 2

thanks

[maximus]

It is not very clear what your really want to do. I would like to suggest that Totals like Total Item should be a calculative field rather than a Field in the Table.

Dcount can be effectively used to do this.

Example of DCount:
Counting No of members:

Dcount("[Mamber_id]","tblmember")

Dcount Can be used with Criteria:
Count All registered members;
Dcount("[Member_id],"tblmember","[Registration]=True')