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 / Forms Programming / January 2005

Tip: Looking for answers? Try searching our database.

Form in Data Entry mode

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rosemary - 28 Jan 2005 03:05 GMT
Hi,

On my switchboard, I have an option called "Enter New Job".  When clicked,
the command button calls a macro that opens our Main Form in Data Entry mode
and gives you a blank form in which to do data entry.

There is also a command button on the menu bar called "Enter New Job".  You
can use it to get a new blank record if you want to enter more than one new
job.  Right now, all the "new jobs" you enter remain visible until you exit
the "Enter New Job" form and go back to the switchboard.

What I would like to do is provide a command button called "Save New Job"
which will then "hide" the new job just entered, before providing a new blank
record.  This way, you will always have just a blank record to fill in,
rather than all the jobs you entered in addition to the blank form.

Do I use the macro to accomplish this?

Thanks,
Penguin - 28 Jan 2005 07:11 GMT
Try using this code in the OnClick of the button:

DoCmd.RunCommand acCmdSaveRecord
DoCmd.RunCommand acCmdRecordsGoToNew

Hope this helps.

>Hi,
>
[quoted text clipped - 15 lines]
>
>Thanks,
 
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.