Copy previous record fields into new record form fields

[Pat Hartman]

You're getting advice on how to work around the problem of an unnormalized schema. If you want to build a better foundation, please start a new thread with that as a goal so we can be clear what we are trying to do and we are not offering contradictory solutions.

 

[PuzzledNH]

You're getting advice on how to work around the problem of an unnormalized schema. If you want to build a better foundation, please start a new thread with that as a goal so we can be clear what we are trying to do and we are not offering contradictory solutions.

Hi Pat,
I was thinking the same thing. I opened a new thread in the TABLES forum called Table Design & Relationships to pursue the disorganized tables.
This thread will remain limited to copying data to a new record.
Thank you.

 

[PuzzledNH]

No. I said to scrap the before update event entered by mistake

Option Compare Database
Option Explicit

Private Sub Product Line_AfterUpdate()
Me.[Product Line].DefaultValue = "'" & Me.[Product Line] & "'"
End Sub

Thank you for the clarification. It helps my understanding. I typed the code exactly as you provided and get an error message. "Compile error. Expected end of statement."
Attached are a couple of images showing the info entered (Capture1) and the error message (Capture2).
Any help to fix this is appreciated.
Thank you.

 

[jdraw]

For reference - do not use field or object names with embedded spaces - to avoid syntax errors that will materialize sooner or later.

 

[apr pillai]

For reference - do not use field or object names with embedded spaces - to avoid syntax errors that will materialize sooner or later.

If you don't mind spending some time to copy paste some Code, try this link for duplicating fields from previous record: https://www.msaccesstips.com/2012/02/duplicating-fields-with-conditional.html



Sent from my iPhone using Tapatalk

 

[isladogs]

Sorry. As already pointed out, the issue was the embedded space in Product Line. The code should have an underscore as shown in RED below

Option Compare Database
Option Explicit

Private Sub Product[B][COLOR="Red"]_[/COLOR][/B]Line_AfterUpdate()
Me.[Product Line].DefaultValue = "'" & Me.[Product Line] & "'"
End Sub

 

[isladogs]

If you don't mind spending some time to copy paste some Code, try this link for duplicating fields from previous record: https://www.msaccesstips.com/2012/02/duplicating-fields-with-conditional.html

Hi apr
That's a neat use of the tag property. Just added to your rep points!

If its OK with you, I'd like to add a link to that webpage from a similar item on my website where I use the tag property to set the visible/hidden, enable/disabled, locked/unlocked state of a group of controls at once

Set Controls

This demonstrates a way of setting the state of a group of controls at the same time using the controls' Tag property

www.isladogs.co.uk

EDIT
Your site would also be a useful addition to this webpage Useful links. Is that also OK with you?

 

[apr pillai]

Hi apr
That's a neat use of the tag property. Just added to your rep points!

If its OK with you, I'd like to add a link to that webpage from a similar item on my website where I use the tag property to set the visible/hidden, enable/disabled, locked/unlocked state of a group of controls at once
See http://www.mendipdatasystems.co.uk/set-controls/4594398114

EDIT
Your site would also be a useful addition to this webpage Useful links. Is that also OK with you?

Ok, I will add your link to my Website.


Sent from my iPhone using Tapatalk

 

[isladogs]

Hi apr
Thanks for that as well. I'll update my website accordingly later.

 

[apr pillai]

Hi apr

Thanks for that as well. I'll update my website accordingly later.

Thank you. Your link is placed on the Right Side-Bar of my Website.


Sent from my iPhone using Tapatalk

 

[isladogs]

Hi apr
That's a very quick way of adding useful links! Wish I'd thought of that

Now added links to your site on the following pages:

TIP: How to fill down in Access tables, queries and forms

As is widely known Excel has a very useful autofill feature. AFAIK much less well known is the Access 'equivalent' which allows you to copy the value from the same field in the previous record to the current record To do so use the keyboard shortcut Ctrl+' (apostrophe) This works both to fill...

www.access-programmers.co.uk

Fill Down in Access Tables, Queries & Forms

This describes a keyboard shortcut to copy the value from the same field in the previous record to the current record

www.isladogs.co.uk

Access Articles

A collection of useful links for Microsoft Access developers including forums, help sites and videos.

www.isladogs.co.uk

Set Controls

This demonstrates a way of setting the state of a group of controls at the same time using the controls' Tag property

www.isladogs.co.uk

I think that covers it!

 

[apr pillai]

Hi apr
That's a very quick way of adding useful links! Wish I'd thought of that

Now added links to your site on the following pages:
https://www.access-programmers.co.uk/forums/showthread.php?t=297833
http://www.mendipdatasystems.co.uk/#/fill-down-tip/4594424203
http://www.mendipdatasystems.co.uk/useful-links/4594464718
http://www.mendipdatasystems.co.uk/set-controls/4594398114

I think that covers it!

Hi isladogs,

Sure it does. Thanks a lot.


Sent from my iPhone using Tapatalk