I use a subform where I would like some of the fields to carry over the last entry into the next record. There is for instance a date field that would be used again for the next 6 or 7 records before it changes. How can I do that, preferably for selected fields but if that is not possible than for all fields.
Scott Axton 2 years ago
Check out the Value From a Form video.
I think that would give you a start.
Once you advance enough and feel more comfortable with VBA you can start using Variables, DLookup, DMax to grab values and "bring them along with you" in to the next one.
Kevin Yip 2 years ago
When you are in a textbox, press:
Ctrl + '
Press and hold Ctrl, and press apostrophe (or single quote).
That will automatically enter the value from the previous record of that textbox into the current textbox. I use this all the time, especially on datasheets or continuous forms.
If you want an entire row to be copied over to the next row, you'll need some VBA programming.
Google "Keyboard shortcuts for Access" to get all the shortcuts from Microsoft support.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
TechHelp.
The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
