Make new Record (1 Viewer)

K

kirkm

Registered User.

Local time

Today, 18:51

Joined

Oct 30, 2008

Messages

1,257

• Feb 13, 2019

• #1

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

 

Ranman256

Well-known member

Local time

Today, 02:51

Joined

Apr 9, 2015

Messages

4,339

• Feb 13, 2019

• #2

There's no NEW button at the bottom record controls. (Bottom left corner)
The NEW button is the STAR button.

 

K

kirkm

Registered User.

Local time

Today, 18:51

Joined

Oct 30, 2008

Messages

1,257

• Feb 13, 2019

• #3

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

 

theDBguy

I’m here to help

Staff member

Local time

Yesterday, 23:51

Joined

Oct 29, 2018

Messages

21,455

• Feb 14, 2019

• #4

Hi. If you want to use code, you could try

Code:Copy to clipboard

DoCmd.GoToRecord , , acNewRec

 

K

kirkm

Registered User.

Local time

Today, 18:51

Joined

Oct 30, 2008

Messages

1,257

• Feb 14, 2019

• #5

Thanks, should have remembered that. Working great.

 

theDBguy

I’m here to help

Staff member

Local time

Yesterday, 23:51

Joined

Oct 29, 2018

Messages

21,455

• Feb 14, 2019

• #6

kirkm said:

Thanks, should have remembered that. Working great.

Click to expand...

Hi. You're welcome. Ranman and I were happy to assist. Good luck with your project.