fields change when picking other value in listbox

  • Thread starter Thread starter Jean-Paul
  • Start date Start date
J

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)
 
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)
Click to expand...

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".
 
Perfect... problem solved...
Great help, thanks you soo much (probably also a very dumb question)
JP
 
Back
Top