var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Automatically selecting an item from a listbox.
I have a listbox that has two columns, the first column is hidden and it is the primarykey/id of a table. The second column, is the text that is visible.
I am running code that pulls DAO queries. after the result of the query, I want to set the listbox based on the result.
So if the ItemID tied to the result of my query is 23, and that item is "Soap" I would like to have Soap automatically selected in my Listbox.
However, if I set:
ListboxName = 23
then 23 is displayed in the listbox.
I could join the query on another table to pull the text for Item 23, but I feel like that is somehow unnecessary since the RowSource for the listbox is already pulling that information down.
Is there an easy way to do this?
Set the width of the first column in your listbox to 0"
Example: ColumnWidths = 0";3"
okay...that's what I thought...something wasn't going right, though...I got frustrated, deleted the form and started over....it works much better now....thank you for confirming that I was not insane...