Command Button to create new record on click.

[Becky]

I have a comments section on a form in my database. i would like to set a
command button to insert a new comments form on click so that i can track
each new comment with the same information. i created a "new comment form" i
just don't know how to get that form inserted into the current form when the
command button is clicked. Help?

 

[John Vinson]

I have a comments section on a form in my database. i would like to set a
command button to insert a new comments form on click so that i can track
each new comment with the same information. i created a "new comment form" i
just don't know how to get that form inserted into the current form when the
command button is clicked. Help?

I think that your terminology may be confusing - or your concept of
how Forms work, I'm not sure which!

Do you want to create a new RECORD in the Comments table? What are
your tables, and how are they related?

Or do you (very oddly) want to create a completely new Form object,
with header, recordsource, controls, background color, etc. etc.?

Step back and explain what you are trying to ACCOMPLISH. I don't think
that creating a new Access Form object is going to be involved! If you
just want to enter a new record on a form, simply go to the new record
using the *> navigation button - or, we can give you VBA code or a
macro to very easily do so.

John W. Vinson[MVP]