Unanswered: Pick Row in Datasheet, Show Details in Single Form
I have been trying to make something work here but not sure how exactly to do it. Continuous forms? Query with a WHERE Clause?
Here is the problem:
I have datasheet that displays a number of records with data coming from 3 tables. My idea is to put that datasheet as subform in another form where each of the fields in a row will be textboxes, combo boxes etc. When the user picks a row from the datasheet, I want the data to be displayed underneath in tabular format so that the user can see it easier, print it, edit it and so on.