Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 02-13-2019, 03:18 PM   #1
kirkm
Newly Registered User
 
Join Date: Oct 2008
Posts: 639
Thanks: 23
Thanked 5 Times in 5 Posts
kirkm is on a distinguished road
Make new Record

I have a Form based on a query, displayed in datasheet view. I use the after update event in one field to process that new data and move to the required fields.

Which works great, except now I want to add a new record and move the data to fields in the existing and new record but there is no Me.Move Next.

How might I achieve that ? Thanks

kirkm is offline   Reply With Quote
Old 02-13-2019, 03:30 PM   #2
Ranman256
Newly Registered User
 
Join Date: Apr 2015
Location: KY,USA
Posts: 3,327
Thanks: 0
Thanked 732 Times in 717 Posts
Ranman256 will become famous soon enough Ranman256 will become famous soon enough
Re: Make new Record

There's no NEW button at the bottom record controls. (Bottom left corner)
The NEW button is the STAR button.
Ranman256 is offline   Reply With Quote
Old 02-13-2019, 03:38 PM   #3
kirkm
Newly Registered User
 
Join Date: Oct 2008
Posts: 639
Thanks: 23
Thanked 5 Times in 5 Posts
kirkm is on a distinguished road
Re: Make new Record

You mean click it ? I really want the after update code to do it all.

kirkm is offline   Reply With Quote
Old 02-13-2019, 04:21 PM   #4
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 3,063
Thanks: 36
Thanked 732 Times in 715 Posts
theDBguy will become famous soon enough theDBguy will become famous soon enough
Re: Make new Record

Hi. If you want to use code, you could try
Code:
DoCmd.GoToRecord , , acNewRec
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 02-13-2019, 04:27 PM   #5
kirkm
Newly Registered User
 
Join Date: Oct 2008
Posts: 639
Thanks: 23
Thanked 5 Times in 5 Posts
kirkm is on a distinguished road
Re: Make new Record

Thanks, should have remembered that. Working great.
kirkm is offline   Reply With Quote
Old 02-14-2019, 08:26 AM   #6
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 3,063
Thanks: 36
Thanked 732 Times in 715 Posts
theDBguy will become famous soon enough theDBguy will become famous soon enough
Re: Make new Record

Quote:
Originally Posted by kirkm View Post
Thanks, should have remembered that. Working great.
Hi. You're welcome. Ranman and I were happy to assist. Good luck with your project.

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Functionality to add a file (make a copy, record the path) to a record (Access2007) AOB General 1 01-03-2014 09:59 AM
Split form make record current record avtuvy Forms 9 05-24-2010 12:46 PM
make sure a record is not entered twice Jon123 General 21 03-16-2009 10:42 AM
How do I make my field inputs stay when I make a new record?? gunwax Forms 1 10-14-2004 07:57 AM
Make a record the current record with compound key bojbrown Forms 1 08-20-2004 07:41 AM




All times are GMT -8. The time now is 03:48 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World