control display of subform in single view property

[gykiang]

Hi all



Is there any way to control display of subform to show only the last record ? Currently I had set the view property of both main & subform to Single & control with insertion of a page break on the subform. Unless I have only record, then it works fine with the subform embedded in the main form showing only one record, or otherwise the subform will display all records if there are more than one in continuous view though the main form remains in single view.

The Subform has no relationship with main form with 2 fields of [ReferenceNo] and [ExecutionDate] whereas main form is conditional consisting of many filtered fields. The subform is embedded in the header of the main form. The purpose is just to show for print out of the summary form in hard copy.

I'm not familiar with VB & will not understand the solution if in codes.

Any clues ?

Thanks for the assistance.

Regards
Kiang

[gykiang]

Sorry, it just strikes my mind.

Is it possible to create a query for the subform to filter only the last record (or latest entry) of [ReferenceNo] and [ExecutionDate] ?

If yes, what criteria to be written on the query design of either of the fields ?

Regards
Kiang

[amrut]

Is it possible to create a query for the subform to filter only the last record (or latest entry) of [ReferenceNo] and [ExecutionDate] ?

Yes, you can. Set the subform's record source to the query. Sort the query by an appropriate field so that the required record appears at the top as first record and the in query design view, change the number of records to be returned from All to 1. Alternatively, after you sort the query by an appropriate field so that the required record appears at the top as first record, switch to the SQL view and replace the SELECT with SELECT TOP 1.

[gykiang]

Thanks Amrut.

Can I know how to perform this task : "in query design view, change the number of records to be returned from All to 1" ?

Regards
Kiang

[June7]

Open query in Design View, look at the Property Sheet, set the TopValues property to 1. This will modify the SQL statement which can be seen in SQL View.

[gykiang]

Thanks to all !
I got it . That's cool... & it works exactly perfectly to what I wanted

Regards
Kiang