ANSWER NEEDED

  • Thread starter Thread starter matt donker via AccessMonster.com
  • Start date Start date
M

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
 
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
 
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?
 
I could, but why type a detailed response when you can read a previous one?

Use the resources available.
 
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?
Click to expand...

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]
 
Back
Top