In a Base form, I’d like to select only one information (lets say ID) and have others (e.g. name) auto write in. So I select ID number from list and name field will be automatically filled with name connected to the said ID.
Newest LibreOffice.
Thanks for help!
This is easily done using a filter table and push button without using macros or simply a list box without a push button but using a macro to automatically retrieve the data. Both methods are presented in the attached sample.
Sample: SelectCompanyByFilter.odb
In the non-macro method, the filter table acts as a storage media for the wanted selection and the push button refreshes the form to obtain the desired selection. In the macro method, the selected item is used in the form filter to retrieve the data.