var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: query help
hi all...i'm a newbie in access
so i need help about something simple.
i want a listbox to be filled with all the values that are returned from a query.
thanks in advance.
Re: query help
The list box wizard should pop up and give you that option.
thanks but i don't want the listbox to be filles with the query when i open the form.I want it to be filled after i run the query(which get the correct parametres after i fill in a combo box)..
On the after update event of your combo box, set the RowSource of the Listbox to the query you are using to populate it
Private Sub MyCombo_AfterUpdate()
If MyCombo & "" <> "" Then
MyListBox.RowSource = "MyQuery"
How do you run your query, is there a button you click to run it? If so, you may be able to use an IF statement?
Let me know and I will tell you the best way i know how. Something along the lines of if the query hasnt run, then say NO VALUES and if it has run, show the values you want.
If your not into CODING, this would be your best solution, it just involves making a macro.