Hi guys and gals lol,
Newbie to the forum and world of access.
I have searched the forum for a solution and found one that works in part,
DoCmd.OpenForm "frmfleettruck", acNormal, , "[unitid]=" & Me.searchresults.Column(0)
This takes me from a list box on a double click event which id fine but how do I modify this so that once the frmfleettruck form opens it opens to the selected record but also allows me to view all other records too. At the moment i am taken to that one specific record and cannot see any other records.
Cheers
Newbie to the forum and world of access.
I have searched the forum for a solution and found one that works in part,
DoCmd.OpenForm "frmfleettruck", acNormal, , "[unitid]=" & Me.searchresults.Column(0)
This takes me from a list box on a double click event which id fine but how do I modify this so that once the frmfleettruck form opens it opens to the selected record but also allows me to view all other records too. At the moment i am taken to that one specific record and cannot see any other records.
Cheers
