Hello: I am setting up a contacts dba. I have a main form which allows the
user to hit a contacts command button which pops up the contact form. I'd
like multi functionality on the contacts form, allowing the user to input new
data as well as search for data. I have new contact command button as well
as search options ont he contact form.

I'd like the user to be able to enter data on the contact form via new
contact command button. Is this possible or do I need a sub form to add
contact data to master table.
--
DB

Put the following in the 'New Contact' button's Click event procedure to move
to a new blank record for adding data:

DoCmd.GoToRecord acForm, Me.Name, acNewRec

The form must be bound to the Contacts table, or to an updatable query on
the table, and have its AllowAdditions property True (which is the default).

Ken Sheridan
Stafford, England

"db" wrote:

> Hello: I am setting up a contacts dba. I have a main form which allows the
> user to hit a contacts command button which pops up the contact form. I'd
> like multi functionality on the contacts form, allowing the user to input new
> data as well as search for data. I have new contact command button as well
> as search options ont he contact form.
>
> I'd like the user to be able to enter data on the contact form via new
> contact command button. Is this possible or do I need a sub form to add
> contact data to master table.
> --
> DB

Put the following in the 'New Contact' button's Click event procedure to move
to a new blank record for adding data:

DoCmd.GoToRecord acForm, Me.Name, acNewRec

The form must be bound to the Contacts table, or to an updatable query on
the table, and have its AllowAdditions property True (which is the default).

Ken Sheridan
Stafford, England

"db" wrote:

> Hello: I am setting up a contacts dba. I have a main form which allows the
> user to hit a contacts command button which pops up the contact form. I'd
> like multi functionality on the contacts form, allowing the user to input new
> data as well as search for data. I have new contact command button as well
> as search options ont he contact form.
>
> I'd like the user to be able to enter data on the contact form via new
> contact command button. Is this possible or do I need a sub form to add
> contact data to master table.
> --
> DB