Carry over Combo Box ValuesUpload ImagesLink Caleb Hansen 13 months ago
I'd like some of my Combo boxes to carry over values from the previous record to reduce clicks. I think this has something to due with the Beforeinsert sub, but I can't quite get it figured.
Juan C Rivera 13 months ago
dlookup I cant find it but richard also has a tech help video in which he copies some fileds onto the next record. hope this helps.
Scott Axton 13 months ago
There are several ways to accomplish what you want to accomplish.
The video Juan was referring to is Duplicate Record. Specifically the extended cut.
You could also set up a 'default' value on a different form like in the Value From a Form video.
It would also be possible to place a second ComboBox on your current form that has the Default value that isn't bound to the form then reference that combo for your default in your data entry.
Kevin Yip 13 months ago
While the cursor is inside the combo box (or any control), press Ctrl+' (control-single quote) to automatically enter the previous record's value of that control.
Caleb Hansen 13 months ago
Scott. Worked great. Thank you
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
