I don't know why people who have not been on rockets continue to ask, "you're not scared?" No we were not scared... until something happens, then it's time to get scared.
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 3 years 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 3 years 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 3 years 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 HansenOP 3 years 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.
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.
