ANSWER NEEDED

[matt donker via AccessMonster.com]

Not positive if what i want to do is even possible or if it is in what way
to do it.

Okay i have a table with tons of information of fixtures including two
fields called Parts used for and fixture#.

What i want to do is have a form with two list boxes. One contains part
numbers and the other contains fixture numbers but only different numbers
on each case.

Now i want the user to be able to go in and pick from either box and when
the user does this it will automatically change the data in the other box
to match what is available.

As in someone selects a part number in the first listbox and this then
updates the second list box to only fixtures which are used for that part
number. Or vice versa someone selects a fixture number and this updates
the partnumber list box to only part numbers that the fixture number is
used for.

Is this possible?

And if so how?

Thanks Matt

 

[Rick B]

Please do not post every hour.

Have you bothered to search for your own answer since you have such an
urgent issue?

This is called cascading combo boxes. It is very common and you should be
able to find hundreds of posts on it. When I searched I found 348 posts and
I would guess that about half of them directly relate to your question.


http://groups-beta.google.com/groups?q=microsoft.public.access+cascading+combo

 

[matt donker via AccessMonster.com]

Ha post every hour eh buddy and when i searched i also found 348 records
that did not anwer my question. And no this is not urgent but i do need an
answer at some point and the problem is if i don't get one today nobody
posts to old comments and therefore i will never get one. PS if this was
so easy why couldn't you answer it directly????
Figured as much

 

[matt donker via AccessMonster.com]

Also i figured it out for myself since i couldn't find the answer i needed
on here using vb code. My main problem which i probably should have
mentioned is trying to get the result in my "CASCADING COMBO BOXES" to not
display the same result twice. IE change the unique value of the query i
place in the row source to yes in vb code?

 

[Rick B]

I could, but why type a detailed response when you can read a previous one?

Use the resources available.

 

[John Vinson]

Also i figured it out for myself since i couldn't find the answer i needed
on here using vb code. My main problem which i probably should have
mentioned is trying to get the result in my "CASCADING COMBO BOXES" to not
display the same result twice. IE change the unique value of the query i
place in the row source to yes in vb code?

Why not just base the listbox (or combo box) on a Unique Values query
in the first place? No need to change it in code.

John W. Vinson[MVP]