N
ngan
John (and anyone else),
I am using your sample code (the one about the animal shelter) but I'm
having some issues applying it to my form. I have a table of taxi companies.
I have a subtable of cities they serve (a junction table). I want the feel
of a multiselect listbox for the user to use (instead of having a combo box
where they have to manually selecta record for each city).
For a taxi company, if a user selects more than one city, your code does
append and delete the data correctly.
My problem is when a user goes to a record, I need the listbox to show what
cities they selected for that taxi. I'm thinking to put a modified code in
the OnCurrent of the form...but I'm not sure what the code is to have the
cities be selected in the listbox.
Can you help?
I can post your code if you want (it's kinda long so I didn't do it in this
posting).
Thanks.
Ngan
I am using your sample code (the one about the animal shelter) but I'm
having some issues applying it to my form. I have a table of taxi companies.
I have a subtable of cities they serve (a junction table). I want the feel
of a multiselect listbox for the user to use (instead of having a combo box
where they have to manually selecta record for each city).
For a taxi company, if a user selects more than one city, your code does
append and delete the data correctly.
My problem is when a user goes to a record, I need the listbox to show what
cities they selected for that taxi. I'm thinking to put a modified code in
the OnCurrent of the form...but I'm not sure what the code is to have the
cities be selected in the listbox.
Can you help?
I can post your code if you want (it's kinda long so I didn't do it in this
posting).
Thanks.
Ngan