Marcel2586
Registered User.
- Local time
- Yesterday, 19:49
- Joined
- Mar 1, 2012
- Messages
- 41
Hello all and first of all, Sorry for the question.
I have been looking for days on the net for my listbox problem.
It is there and found a few, even on this forum. but when i try the solutions mentioned i am in a total loss and do not know what to change to make it work for me.
I have a form named A/B Retriever with a record source qry input AB Bins
Than i have a unbound combobox with row source qry input AB Bins.
This populates 8 textboxes with B through I carton boxes, stored in a bin.
The user selects a Bin location from the combobox and can put a "x" in a textbox to illustrate that the box is empty. This works perfect.
Underneath the input bin and box part i have 8 listboxes that shows a query that has counted the empty boxes with the corresponding bin location.
this also works. but the question from users where, If i click on a, lets say empty B-box at Bin location 12A20, they want the combobox automatically focus on the combobox with the corresponding Bin location. This is a quick way for them to delete a empty box (remove the X).
How could i solve this, i know that i have to use VBA and a Me! but than i loose track.
See attachment for the database. (sorry for the dutch language in the database)
Thank you very much in advance.
I have been looking for days on the net for my listbox problem.
It is there and found a few, even on this forum. but when i try the solutions mentioned i am in a total loss and do not know what to change to make it work for me.
I have a form named A/B Retriever with a record source qry input AB Bins
Than i have a unbound combobox with row source qry input AB Bins.
This populates 8 textboxes with B through I carton boxes, stored in a bin.
The user selects a Bin location from the combobox and can put a "x" in a textbox to illustrate that the box is empty. This works perfect.
Underneath the input bin and box part i have 8 listboxes that shows a query that has counted the empty boxes with the corresponding bin location.
this also works. but the question from users where, If i click on a, lets say empty B-box at Bin location 12A20, they want the combobox automatically focus on the combobox with the corresponding Bin location. This is a quick way for them to delete a empty box (remove the X).
How could i solve this, i know that i have to use VBA and a Me! but than i loose track.
See attachment for the database. (sorry for the dutch language in the database)
Thank you very much in advance.
Last edited:
