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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Switchboard: add record 1

Status
Not open for further replies.

Fredgarner

Technical User
Jul 21, 2005
29
GB
Does anyone know how I can get a command button that will allow someone to add a new record to a particular form? It is possible to do this by using the switchboard manager but I cannot find a command button that will do this in design view.
 
You will find
DoCmd.OpenForm "YourFormName".....

Change it to

DoCmd.OpenForm "YourFormName", , , , acFormAdd


________________________________________________________________________
Zameer Abdulla
Visit Me
Children are poor men's riches.
 
Hi Fred

ZmrAbdulla is right if you want to delve into VBA. If not then there's a 'add new report' command under 'record operations' in the wizard when you put a new command button on the form.

Ian Mayor(UK)

Program Error
Programmers do it one finger at a time!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top