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

Open Form on New Record

Status
Not open for further replies.

nickotine

Programmer
Nov 27, 2001
23
GB
Hi everbody, I have a simple Form (4 Fields) which reads from a table, how can I make this Form on a New record.

Please Help.

Thanks,

Nickotine.
 
Create a macro that opens the form, in the details section open it in add mode, this will open the form to a new record.

Thanks
Chris
 
If you are wanting to automatically open the form to a new record;

In Form design, create a command button to open a form;
in the On Click event, select Event Procedure; then type in the following;

DoCmd.OpenForm "FormName"
DoCmd.GoToRecord , , AcNewRec

Hope this helps.






Thomas Bailey
tomcat@reportcop.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top