Hi,I am wondering how to get a subform to automatically move to specific record. I thought I could just create a DAO recordset based on the subform and move through to record I want using FindFirst(condition).
But I can't seem to create a recordset from a subform. Please Help, CHeers
James

all you have to do is go to the form that you want to insert the subform, and in your toolbox, select subform, and the wizard will ask you where you want to get the information from, and just select the subform you already created.

Sorry I don't think my question was ver clear.
I have a list box on a form and when an item is selected in the list box, I take the values of one of the selected columns. When one of these Items is selected I need the subform to go to the record based on this variable.