Hi, I'm trying to create a form that would show records from existing query and use them to add new record to table based on on this selection. I have a TblClients, TblCounsellors which are joined through a table called TblCounselling. I have a query called qryWaitingList which shows all the Clients not currently in Counselling. I would like to look at the qryWaitingList and select a Client to add to the TblCounselling along with a combo box of Counsellors in order to create a new Counselling record but I've tried a number of subform combinations but none seem to work. Can anyone help me with this