Hi, I am trying to do something that I thought would be simple, but not having much success.

I have a form with a subform in it. The subform is tied to the ID of the form, so that I can add "notes" and each record will be attatched to the correct main form record.

So, I want a button on the main form that when clicked will add a new record, and put focus on the new record in the sub form. (even if I had to put the button on the sub form itself to make it easier, that is ok, but I would prefer the button on the main form). I did use the design view, and put the button with record operations, add new button, etc. but when this is clicked, it does nothing. The new record is already added waiting for you to click and type in it, so what is the button used for then? I would expect it to at least put focus on the new record when clicked. Or what would be even better is in the sub form, I turn the additions off so the new record is not sitting there, then when you click add new record, it adds one and puts focus on it. Why wont the built in button do this? And how can I do this?

Thanks in advance!