I currently have a form with 3 subforms attached!

All the forms display data in a datasheet format!

On one of the subforms, I want to be able to click on only a new record and take the user to a new form that basically is like Add.
This way the user can see a form rather than the datasheet view...

How can I do this!

Thanks

In one of the fields, in the form that is form for the subform, in the Double Click event use code to open the form you want the user to see. This way they can double click in that field on any record and go to your form to add a new record.

HTH,
Jack

Jack,

If you are looking in, have you any code examples because I am trying to do the same.

Thanks
Mark

northwind.mdb has examples of this. They do it in a button click event but you could put the code in the double-click event of a regular field.