I know there was a lesson that talked about adding records using a List Box and/or Combo Box. Can someone refer me to that lesson or Teck Help. I don't know if you can add a record in both or just one of these Controls. I have a need to do this in my Password Data Base that I built. Thanks
John
Donald Blackwell
@Reply 5 months ago
Are you talking about being able to add items to combo boxes? Like in the List Items Edit Form
John SchreiberOP
@Reply 5 months ago
Yes. But, if it is not possible I will have to do with list Box
Donald Blackwell
@Reply 5 months ago
With a List Box, you can't type a new value directly into the list, you have to use the list items edit form which you get to from either the little icon that pops up when the field has focus, or through some other action like a double-click event.
If you are trying to just use the little icon that pops up to access the form, that is quirky because, once you've clicked into the list box, that disappears. It will only re-appear if the list loses focus and then gains focus again. Such as by tabbing to another field and then tabbing back, but then as soon as you select a new option, it disappears again.
However, once you've gained access to the edit form, it should work the same as the video linked above. List boxes and Combo boxes don't typically add records themselves but merely reflect records that exist either in the control itself, such as a value-list type, or via a table or field list. The edit form is what actually adds/edits/deletes records.
John SchreiberOP
@Reply 5 months ago
Thanks Mr. Blackwell. But can this be done at all on a combo box?
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
Access TechHelp.