fields change when picking other value in listbox

[Jean-Paul]

Hi,
(me again)

I have this form based upon a todo_table.
On the form I created a listbox with all "subjects"(=field from a
record) I get from a todo_table.

There are also 10 other fields on this form.

Now, I thought, by picking another "subject" from the listbox, the
values of the other fields should automatically change too...
But, nothing happens.

I did a Me.Refresh, but, no result...

Any help is welcome
Thanks

JP, Belgium (the most chaotic country in the world)

 

[John W. Vinson]

Hi,
(me again)

I have this form based upon a todo_table.
On the form I created a listbox with all "subjects"(=field from a
record) I get from a todo_table.

There are also 10 other fields on this form.

Now, I thought, by picking another "subject" from the listbox, the
values of the other fields should automatically change too...
But, nothing happens.

I did a Me.Refresh, but, no result...

Any help is welcome
Thanks

JP, Belgium (the most chaotic country in the world)

Ummm... no. Picking a new value from the listbox will simply overwrite
whatever was in the field to which the listbox is bound with a different
value, the one you picked!

If you want a listbox (or combo box) to cause the form to navigate to a
different record (displaying different values for the other controls on the
form), you need an *unbound* list/combo box with some VBA code attached to it.
The combo box wizard will do this for you - choose the option "use this combo
to navigate to another record".

 

[Jean-Paul]

Perfect... problem solved...
Great help, thanks you soo much (probably also a very dumb question)
JP