How to use the last entry in a subform to update fields in a Table

[Shouer]

Hi there,



I have a data base in which I have a main table with the details of my records and I also have another table with some date details. For example one person from the main table may have only one entry for date details in the subform and some other person may have 3 date entries in the subform. My main table contains of the same date details fields and I would like to find the way to update those fields in the main table taking the corresponding data from the last entry in the subform.

I am aware of the Update Query existence but I have never used this.

Can some one give me some tips on this?

Thank you,
D.

[ranman256]

in your query, use the picker (it always gets the syntax correct)
to reference the subform fields. usually: forms!frmMain!subform!form!txtDate

if the user has the cursor on the subform record, THATS the record that is used in the query.
Be sure to reference the key ID of the record too.

[orange]

shouer,

Can you describe what your business is in plain, simple English --no database jargon?