Cascading Combobox

[hinchi1]

Hi,
Please have a look at the updated file, I have replaced your combos with a subform bound to a new join table that tracks the roomid/researchgroupID (added a date range in there if you need to add a temporal twist to it).
Cheers,


Vlad

Hi Vlad
I like the subform as it gives more flexibility. After selecting research groups. How could I display these groups on frmRoomBuildingDetails in say one textbox that are comma separated?

[Gicu]

Lookup JoinFromArray on my website or Google concate related function by Allen Browne.
Cheers,
Vlad

[hinchi1]

Lookup JoinFromArray on my website or Google concate related function by Allen Browne.
Cheers,
Vlad

Cheers. Much appreciated

[hinchi1]

Just had a quick look. Beyond my knowledge. A bit of homework needed I think.

[Gicu]

I can help you a bit later today when I get back home.

[hinchi1]

I can help you a bit later today when I get back home.

Thank you. This is not my day job, just something I enjoy and find really interesting. I understand a lot of VBA when looking at it, but not my main skill to write it. I really appreciate the help given here.

[Gicu]

Tell me about, I used to be a forester .....but love Access and VBA now!

[hinchi1]

Tell me about, I used to be a forester .....but love Access and VBA now!

Mechanical engineer by trade, aerospace work. Always good to have diverse skills though.

[Gicu]

Here you go, have a look at how I used the public function vcJoinFromArray in the query and I'm sure you will understand how it works.

Cheers,
Vlad

[hinchi1]

Here you go, have a look at how I used the public function vcJoinFromArray in the query and I'm sure you will understand how it works.

Cheers,
Vlad

Nice one. Will have a look in the morning. As always much appreciated.

[hinchi1]

Here you go, have a look at how I used the public function vcJoinFromArray in the query and I'm sure you will understand how it works.

Cheers,
Vlad

Hi Vlad

Thanks for this, just what i want. one thing i do need to figure out that i noticed. if i delete a research group from the subform the record is not deleted in full from the table, tblresearchgroupjoin. the research groupid is deleted from the record line but not the roomid. i am sure i can work this out. i need to be able to delete groups from rooms as we always moving groups around.

[Gicu]

Don't just empty the combo box, but delete the entire record (click the record selector on the right and press the Delete key).

Cheers,

[hinchi1]

Don't just empty the combo box, but delete the entire record (click the record selector on the right and press the Delete key).

Cheers,

Cheers. I figured this out after my last post. What you have done is more than I expected, works brilliantly. I just need now to import into main dB. Thanks again for the support.

[Gicu]

You're very welcome, good luck with your project!

Cheers,