autofill from with specific condition check

[dhanesh.koshti]

Dear Members, I want to Autofill one of the field in my form, by checking specific conditions in my database. Example of which is as below:

1. Date of Maintenance :
2. Loom No. :
3. Component Replaced :
4. Component Type :
5. Latest date for same component replacement :

I want to autofill the Sr. No. 5 in the form itself by checking database, and if Sr. No.2=Sr No.3=Sr. 4, then latest date should be autofill in Sr. No. 5

Say, A component was replaced in a Loom on 01/01/2013 & again after six month same component is replaced on 01/06/2013 so while filling up the form, In sr. no. 5 latest date 01/01/2013 of replacement of same component in same loom should be pulled from data base.



Pl. help me...

Thanks in advance

[June7]

Saving calculated values is usually a bad idea. Calculate when needed. The 'latest' date can be retrieved with a query.

[dhanesh.koshti]

pl. explain in detail...i m new for ms access

[June7]

One way is with a GROUP BY (Totals) aggregate query.

SELECT Loom, Component, Max([Date of Maintenance]) AS MaxDate FROM tablename GROUP BY Loom, Component;

Another is DMax() domain aggregate function.

DMax("[Date of Maintenance]", "tablename", "Loom=loomIDhere AND Component=componentIDhere")

Domain aggregate functions can be used in query or textbox on form/report.

Access Help has more guidelines on both, also a lot on web.