contact form

D

db

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.
 
K

Ken Sheridan

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top