I have a form that I use to allow users to Add/Amend/Delete accounts (Chart of Accounts). I have inserted a listbox on the right of the input fields so that as an account is added/updated the user can see the effect on the whole table.
So far so good. However, as the user adds accounts, the list box fills up and as soon as the bottom most entry is added, the listbox spawns a right-hand scroll bar. All good stuff.
However, subsequent records that are added just disappear below the bottom of the listbox. It would be really useful to keep the latest added entries showing.
I have Googled this and apparently I should be using the "ListIndex" and "ListCount" properties of the Listbox. But in my version (Office 365 ie. Access 2016) thesed properties are non-existant. Am I missing a namespace/reference or something? Apparently these properties should be available from Access 2013. Really?
Can anyone help?
So far so good. However, as the user adds accounts, the list box fills up and as soon as the bottom most entry is added, the listbox spawns a right-hand scroll bar. All good stuff.
However, subsequent records that are added just disappear below the bottom of the listbox. It would be really useful to keep the latest added entries showing.
I have Googled this and apparently I should be using the "ListIndex" and "ListCount" properties of the Listbox. But in my version (Office 365 ie. Access 2016) thesed properties are non-existant. Am I missing a namespace/reference or something? Apparently these properties should be available from Access 2013. Really?
Can anyone help?