mamradzelvy
Member
- Local time
- Today, 07:58
- Joined
- Apr 14, 2020
- Messages
- 145
Hello, i'm new to Access and i'm trying to figure out how to make a listbox next to my form show only information based on the input on said form.
I got a table called "dbInventory" with "ID, InvName, InvQuantity, InvType" and a entry form matching these fields.
What i'm trying to achieve is to have the listbox start displaying search results based on the input.
(My ID collumn contains barcodes, not autonumbers)
So for instance, if i scan a barcode for an item i already put in the table some other time, i would like it to appear on the listbox right away.
How would one go about that?
I tried the listbox wizzard and selected the third option which states that the listbox will take information based on entries on the form (sorry my access is in Czech)
However, that just constantly shows all data in my table.
I apologize for grammar mistakes and i would welcome if anybody could at least help me find the right way to ask this question, as i struggle with it.
I got a table called "dbInventory" with "ID, InvName, InvQuantity, InvType" and a entry form matching these fields.
What i'm trying to achieve is to have the listbox start displaying search results based on the input.
(My ID collumn contains barcodes, not autonumbers)
So for instance, if i scan a barcode for an item i already put in the table some other time, i would like it to appear on the listbox right away.
How would one go about that?
I tried the listbox wizzard and selected the third option which states that the listbox will take information based on entries on the form (sorry my access is in Czech)
However, that just constantly shows all data in my table.
I apologize for grammar mistakes and i would welcome if anybody could at least help me find the right way to ask this question, as i struggle with it.