Hi, I use an ado recordset to populate a form in the form_load() event , all is well however, I now need to open this form from another form else where in the app after a user has identified a specific record they wish to use.
This needs to be via a click button, the sub form where they select the record to open uses the following code to display basic details from a main table;
ADOdetailRS.open "select [etc], [etc], [etc] from tblappts where tblappts.[index] = "val(me.[text2]), etc,etc,etc
This gives me core details for a selection, I now need to open the main form based on a click button using the value of txtfield within this form, I know I can create another form and open it with another recordset, but I would rather not create another form.