I have created a "Create New Contact Form" that I would like to add code to the load event in order make sure that it opens in add new record only. I will have a save button that when users click on it will save the record and close the form. But I want to make sure that they can only enter one contact at a time.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Open Form Add New Record Only
- Thread starter puppy39
- Start date
TheAceMan1
Programmer
how are ya puppy39 . . .
[ol][li]Have a look at the forms [blue]Data Entry[/blue] property.[/li]
[li]You can also open a form in add mode only (same as [blue]Data Entry[/blue]) with:
[/li][/ol]
[blue]Your Thoughts? . . .[/blue]
See Ya! . . . . . .
Be sure to see thread181-473997 [blue]Worthy Reading![/blue]![[thumbsup2]](/data/assets/smilies/thumbsup2.gif "[thumbsup2] [thumbsup2]")
Also faq181-2886 [blue]Worthy Reading![/blue]
[ol][li]Have a look at the forms [blue]Data Entry[/blue] property.[/li]
[li]You can also open a form in add mode only (same as [blue]Data Entry[/blue]) with:
Code:
[blue] DoCmd.OpenForm "YourFormName", , , , [purple][b]acFormAdd[/b][/purple][/blue][blue]Your Thoughts? . . .[/blue]
See Ya! . . . . . .
Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]
TheAceMan1
Programmer
puppy39 . . .
BTW: Welcome to [blue]Tek-Tips![/blue] Do have a look at one of the links at the bottom of my post. The links will help you [blue]ask better questions[/blue], get [blue]quick responses[/blue], [blue]better answers[/blue], and insite into [blue]etiquette[/blue] here in the forums. Again . . . Welcome to [blue]Tek-Tips![/blue] [blue]Its Worthy Reading![/blue]
See Ya! . . . . . .
Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]
BTW: Welcome to [blue]Tek-Tips![/blue]
Do have a look at one of the links at the bottom of my post. The links will help you [blue]ask better questions[/blue], get [blue]quick responses[/blue], [blue]better answers[/blue], and insite into [blue]etiquette[/blue] here in the forums. Again . . . Welcome to [blue]Tek-Tips![/blue] [blue]Its Worthy Reading![/blue]See Ya! . . . . . .
Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]
- Status
Similar threads
