Michiel Soede
Registered User.
- Local time
- Today, 07:18
- Joined
- Sep 16, 2012
- Messages
- 12
All,
Hope somebody can help me with something I can't get my head around with. I have a very simple userform of which I want to populate list box "Act_value" with the result of a query which criteria are dependent on selections made in comboboxes. I added the Access file with only the form and the table needed to do so.
Can you let a query (like I did in this file with grouping and criteria included) populate a list box if it comes to values? If so why does it not show my value in "Act_value"? I added a after change event in VBA to update the act value list box ("Me.Act_Value.Requery")
And when do you choose for Dlookup in a situation like this one?
I am very grateful for your response.
thanks,
Hope somebody can help me with something I can't get my head around with. I have a very simple userform of which I want to populate list box "Act_value" with the result of a query which criteria are dependent on selections made in comboboxes. I added the Access file with only the form and the table needed to do so.
Can you let a query (like I did in this file with grouping and criteria included) populate a list box if it comes to values? If so why does it not show my value in "Act_value"? I added a after change event in VBA to update the act value list box ("Me.Act_Value.Requery")
And when do you choose for Dlookup in a situation like this one?
I am very grateful for your response.
thanks,