Jun 8, 2004 #1 nickotine Programmer Joined Nov 27, 2001 Messages 23 Location 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.
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.
Jun 8, 2004 #2 chrisaroundtown Technical User Joined Jan 9, 2003 Messages 122 Location AU 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 Upvote 0 Downvote
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
Jun 8, 2004 #3 ZmrAbdulla Technical User Joined Apr 22, 2003 Messages 4,364 Location AE It is simple Open Properties of the Form > Data > Data Entry = Yes Hope this helps Zameer Abdulla http://www.geocities.com/zameerabd/http://www.mtkhoory.com Upvote 0 Downvote
It is simple Open Properties of the Form > Data > Data Entry = Yes Hope this helps Zameer Abdulla http://www.geocities.com/zameerabd/http://www.mtkhoory.com
Jun 9, 2004 #4 tomcat21 Programmer Joined Jul 28, 2002 Messages 69 Location US 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 http://www.reportcop.comtomcat@reportcop.com Upvote 0 Downvote
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 http://www.reportcop.comtomcat@reportcop.com