I have a QueryA that lists 5 fields from TableA, lets call them Fields1-5. On FormA I have a button that changes the SQL criteria of QueryA such that only one row of TableA is returned. I want to make a listbox that populates based on the fields that are currently present in QueryA. Simply putting the SQL into the listbox rowsource only returns Field1.
I know how to cleanup empty rows in a listbox so the goal here is to simply list the contents of Fields1-5. What would be the most efficient way to go about this?
I know how to cleanup empty rows in a listbox so the goal here is to simply list the contents of Fields1-5. What would be the most efficient way to go about this?