Dear All,

I wonder if you can offer any advice on this one - I have two forms - one parent details and one child details - the parent details is the first user form and at the bottom is a command button to take the user to the child details form (where a parent details cmd button exists). My query is this - in the parent form a Guardian ID is in a bound text box - when the form is completed or looked at and the user moves to the child details - I want the user to move to the correct child record (ie the same guardian id field) and visa versa. I have tried Select SQL and Go to and a little code - any ideas

yours gratefully

suzanna

Suzanna -

Open your parent form in Design View. Create a Command button using the Wizard. On the first screen of the Wizard select "Form Operations" from the left list box and "Open Form" from the right hand box and click Next. Select your child form in the next screen. In the next screen select "Open the form and find specific data to display". Click Next. On the next screen select Guardian ID in each list box and then click the little button between the two list boxes. Click Next and finish the last screen or two. Now when you click that command button your child form will open at the same record as your parent form.

HTH,
Jack

[This message has been edited by Jack Cowley (edited 08-12-2000).]