R
Randy K.
I am using a listbox to gather multiple columns of a query. Originally, it
was designed that many rows could be returned, but now only 1 row will ever
come back. I want the form to open and automatically select that row so
that I can reference items via "listbox.column(x)" If I don't select the
row, the references are all null and if I use "listbox.selected(0)" that I
found somewhere, the row selects, but then the entire form seems locked. I
can't select any other field and nothing allows any entry, but I can move
the form around just fine and close it without any errors.
How can I either autoselect the 1 row without locking up form OR how can I
reference the column values (other than the bound column) from the 1 row
without having to select it? I am also open to using a different control,
but need to be able to define the column widths, if possible, to fit
correctly within the form.
TIA,
Randy
was designed that many rows could be returned, but now only 1 row will ever
come back. I want the form to open and automatically select that row so
that I can reference items via "listbox.column(x)" If I don't select the
row, the references are all null and if I use "listbox.selected(0)" that I
found somewhere, the row selects, but then the entire form seems locked. I
can't select any other field and nothing allows any entry, but I can move
the form around just fine and close it without any errors.
How can I either autoselect the 1 row without locking up form OR how can I
reference the column values (other than the bound column) from the 1 row
without having to select it? I am also open to using a different control,
but need to be able to define the column widths, if possible, to fit
correctly within the form.
TIA,
Randy