Copy previous record fields into new record form fields
- Thread starter PuzzledNH
- Start date
apr pillai
AWF VIP
- Local time
- Tomorrow, 03:04
- Joined
- Jan 20, 2005
- Messages
- 737
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
Access MVP / VIP
- Local time
- Today, 21:34
- Joined
- Jan 14, 2017
- Messages
- 19,297
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
Code:
Option Compare Database
Option Explicit
Private Sub Product[B][COLOR="Red"]_[/COLOR][/B]Line_AfterUpdate()
Me.[Product Line].DefaultValue = "'" & Me.[Product Line] & "'"
End Subisladogs
Access MVP / VIP
- Local time
- Today, 21:34
- Joined
- Jan 14, 2017
- Messages
- 19,297
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?
Last edited:
apr pillai
AWF VIP
- Local time
- Tomorrow, 03:04
- Joined
- Jan 20, 2005
- Messages
- 737
apr pillai
AWF VIP
- Local time
- Tomorrow, 03:04
- Joined
- Jan 20, 2005
- Messages
- 737
Thank you. Your link is placed on the Right Side-Bar of my Website.
Sent from my iPhone using Tapatalk
isladogs
Access MVP / VIP
- Local time
- Today, 21:34
- Joined
- Jan 14, 2017
- Messages
- 19,297
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:
www.isladogs.co.uk
www.isladogs.co.uk
www.isladogs.co.uk
I think that covers it!
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!
Last edited:
apr pillai
AWF VIP
- Local time
- Tomorrow, 03:04
- Joined
- Jan 20, 2005
- Messages
- 737
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
