Activating a form

[IG]

I'm setting up a Contact Management Database, I created a
form in order to add my contacts one at the time, but I'm
not able to activate it. Can someone help me with this?

I would like to enter my client's information and click
the Add Contact button to be recorded on the database.

Thanks so much for your responses.

IG

 

[Graham Mandeno]

Hi Ingride

You activate a form from code using DoCmd.OpenForm. For example, in the
Click event procedure for your button you might have:

DoCmd.OpenForm "frmAddContact", _
WindowMode:=acDialog, OpenArgs:=Me.ClientID

The OpenArgs argument tells the new form which client the new contact
belongs to, and the WindowMode argument prevents the user doing anything
else until the new form is closed.

Another method to consider would be to list the contacts on a subform of the
client form, perhaps on a page of a tab control. Then you could just click
on the contacts page and view/edit/add contacts there.

--
Good Luck!
Graham Mandeno [Access MVP]
Auckland, New Zealand

Return mail address is invalid in a vain attempt to reduce spam.
Feedback is welcome at: (e-mail address removed)
Please post new questions or followups to newsgroup.