Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hello @Roby,

It is difficult to establish just where your current problem is. The original form you present is most likely using a macro to retrieve the data since once a selection is made the data appears.

Regardless of using a macro to retrieve the record or using a push button, the process is known as filtering. Without a macro, the list box is created from entries in an existing table (retrieved by SQL) and the selected item is saved in a "Filter" table. This is like a temporary storage area. You then use a push button to refresh the sub form (where the persons data is displayed). The sub form is obtained by using a Query which selects the appropriate record based upon the selected item in the "Filter" table. Much more on how all this works and how to set up can be found in this post -> Filter/Search with Forms (leveraging SubForms).

Now doing this in a macro works in a similar fashion but operates without a "Filter" table or external query. It also retrieves the record without the need of a push button. However, writing macros, especially for someone new to Base, is a step learning curve.

Many examples using each of the above methods are posted through out this forum. Here is a post containing links to a number of samples -> how to put a search box into a LO Base form

Finally, images (as in your question) typically do not explain where the problem may reside. It is always better to post a sample DB WITHOUT personal or confidential information.