Populating a subform with a recordset

[new2access123]

I am brand new with Access so i know I am not seeing something and the answer is easy. I have created a record set (dbOpenDynaset) that brings together the client, project, test name and scores for a selected participant. (each of these is a separate table client, project, testname, scores and participant.) I will need to edit existing data and append and delete rows. so if i add a row for a new test score the underlying table needs to have the row appended and saved.


My question is how can I populate a subform from the record set so I can add edit and delete? Can some one provide some sample code or direct me to a sample?

 

[Galaxiom]

Just use a normal query for the Record Source property of the form.
You can either enter the sql directly or choose a stored query.