form record entriesUpload ImagesLink Maarten Brusselers 14 months ago
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 14 months 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 14 months 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.
