listbox problems

  • Thread starter Thread starter Chad
  • Start date Start date
C

Chad

I posted this in another group but no one was able to
help me. Maybe someone here can.
Here is my problem.

I have a form that bound to a query. On this form is a
listbox which contains 2 column, each displaying a
different field. Column(0) = [County] and Cloumn[1] =
[State]. Also, on this form, is a checkbox which returns
the field [Pending] depending on which record is selected
in the listbox.

When I select different records from the list box, the
form's recordset never changes (it always stays on the
first record) which causes the checkbox to not display
the correct information. I am able to move between
records with the navigation buttons, but not by selecting
a record in the listbox.

Here is the weird part. The only way I can get the
form's recordset to change when I select a value from my
listbox is if I switch which fields and in which columns
(make column(0) = [State] and column(1) = [County]. I
would like to have the list box display the fields with
county first but I can't seem to figure out why it doesnt
work. Can anyone give me any suggesetions of what may be
happening?

Thanks a lot,
Chad
 
-----Original Message-----
I posted this in another group but no one was able to
help me. Maybe someone here can.
Here is my problem.

I have a form that bound to a query. On this form is a
listbox which contains 2 column, each displaying a
different field. Column(0) = [County] and Cloumn[1] =
[State]. Also, on this form, is a checkbox which returns
the field [Pending] depending on which record is selected
in the listbox.

When I select different records from the list box, the
form's recordset never changes (it always stays on the
first record) which causes the checkbox to not display
the correct information. I am able to move between
records with the navigation buttons, but not by selecting
a record in the listbox.

Here is the weird part. The only way I can get the
form's recordset to change when I select a value from my
listbox is if I switch which fields and in which columns
(make column(0) = [State] and column(1) = [County]. I
would like to have the list box display the fields with
county first but I can't seem to figure out why it doesnt
work. Can anyone give me any suggesetions of what may be
happening?

Thanks a lot,
Chad
.
Click to expand...
You are bound to the wrong column in your list box, You
are not displaying (width set to 0), the proper data for
the listbox, you are not requeryiing your listbox when you
change your recordset, and/or your Onchange event isnt
correct.
 
Back
Top