Form combo dropdown

[Ginny2222]

Hi all,
I'm wondering if the following logic should work. I don't want to waste too much time on it, if it's an impossibility. Your opinion would be much appreciated.

I have a form on which I have 2 combo boxes. I want the 2nd combo box to filter it's list depending on the value in the 1st combo box. I know that this works for tables that have been set up with primary key --> foreign key on the value that is contained in both.

Where I have a problem is that I would like to set up the above using a table and a join query. If possible.

The reason I have a join query is that I have 2 unrelated tables that need to be listed in the dropdown and by joining them I am adding the filter field. This works fine for the dropdown on it's own, but I can't get the filter to work, and I think it may be because I can't get the relationship right.

Any ideas?

rgs
Ginny

 

[YNWA]

Post your DB so people can see your structure.

Try researching cascading combo boxes, this is what you are trying to do.

 

[Ginny2222]

Hi YNWA
I was making it too complicated! It does work using a table and a query, after I watched a video on youTube I realised I didn't need to set up a relationship beforehand. The coding in the AfterUpdate event handled it well.

Thanks for pointing me in the right direction.
rgs
Ginny