ListBox of two Forms base on the same Table/Rowsource

[Jamesy_007]

Yes! Guys as the titled thread suggest....

So i have two(2) Forms base on the same data or table but instead on any programming i just did a little tweak of the sql code that is in the rowsource. i want to separate two(2) groups of people promoted and those not by a checkbox Yes or No field.. here's the problem those not promoted "false" there's a list box with a set of values only for that form.... but those that are promoted there's another different list of values for them of which the user can pick...e.g. so if your promoted only these values can be picked... here is the problem every time i change values of the list box in one form the values change in the other... believe I can solve this but decided to post since i haven't chat with you'll in a while. how to go about this? do i jus create a table with those promoted values and link that table to the form as a combo box...

Hope you'll understand.... two form objects with a slight filt those who are promoted oppose to those not...
if promoted these values alone available in the list box...say "frmEntitiled"
if not promoted these values alone available in this list box...say "frmNotEntitiled"


ps.. and nope its not a cascading combo box problem!... lol

[ranman256]

you need 2 queries,
lstbox1 would use 1
listbox2 would use the other

[Jamesy_007]

you need 2 queries,
lstbox1 would use 1
listbox2 would use the other

Great! works like i want too. know there're different ways to get something done; didn't think i will have to do two (2) queries... make a table of values.... query and so...but this works on both Forms have the correct information now per List on both Forms. One thing don't know why I choose a list box but those values can never change... the font is in red and the default value when highlighted has a black default shade on it can this be adjusted in the properties or best option is to change the font fore color values within the Listbox