subform image link

[anchamal]

i have a form where i need to display the first 6 results (images). the information is comming from a subform which has all the information.


also i need to know after pressing the "next" button how to display the next 6 images from the same subform and so on.
using ms access 2013

[June7]

Dynamic display of images in Access 2003 is not easy. Review

http://office.microsoft.com/en-us/ac...001147204.aspx

http://support.microsoft.com/kb/285820

Wait, your profile says 2003 but the file is accdb.

There is only one field with path to image file. Why do you say 6 images?

[ItsMe]

As for the top 6, maybe something like in VBA or as a query object.

Dim strSQL As String
strSQL = "SELECT TOP 6 Albums.[album name] " _
    & "AS Top6Album, Albums.[albumid] " _
    & "FROM Albums " _
    & "ORDER BY Albums.[album name] DESC;"
Me.RecordSource = strSQL

[anchamal]

sorry it's office 2013