Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / May 2007

Tip: Looking for answers? Try searching our database.

set form for new record

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
balu - 21 May 2007 14:49 GMT
I have a form when ever it is reopened form showing the first record
but insted i want the form to set for new record as it opened
how to do this please
balu
RBear3 - 21 May 2007 14:57 GMT
Set the form's "data entry" property to true.

Signature

Hope that helps!

RBear3
.

> I have a form when ever it is reopened form showing the first record
> but insted i want the form to set for new record as it opened
> how to do this please
> balu
John W. Vinson - 21 May 2007 18:29 GMT
> I have a form when ever it is reopened form showing the first record
> but insted i want the form to set for new record as it opened
> how to do this please
> balu

You can set the Form's Data Entry property to Yes, as Rbear3 suggests; this
will work but has the disadvantage that you cannot then use the form to see or
edit existing records.

An alternative is to open the Form in design view. View the Form's Properties;
on the Events tab find the Load property. Click the ... icon by it and choose
"Code Builder". Access will give you a Sub and End Sub line, just add one
more:

Private Sub Form_Load()
DoCmd.GoToRecord acDataForm, Me.Name, acNewRecord
End Sub

            John W. Vinson [MVP]
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.