Three questions

[someboddy]

1. In continuous forms, is there a way to use a VB command on a single form component? If I want to do something(like changing a textbox) on only ONE form, is there a way to do it?
2. Is there a way to filter the list in a combobox, so some records won't be displayed in the list, but if a value corresponding to one of the filtered out records is selected, I want it to be displayed.
   MMM... that was a little confusing... OK. Lets say I have a table(A) with a number field(X). I also have a table(B) with two fields - a number(Y) and a string(Z). Field X on table A is linked to field Y on table B. I have a form for table A, where I have a combobox that is assigned for field X. But the combo doesn't display the number, it display the corresponding string from field Z on table B, from the record that is linked to that number.
   Until now, it's quite simple. However, table B contains lots of records, so to save the users the trouble of scanning all of them, I want to allow them to filter the list in the combobox via certain categories. The problem is that if I filter a certain record out, and that record is selected, the combobox will be empty. For example, if table be contains (1-Benny;2-Johnny;3-Lenny), and I select Lenny from the combobox, it'll show Lenny, and the number on x at the recordset will be 3. However, if I select a filter that only shows Benny and Johnny, my combobox will be empty, even though Lenny is selected. Is there a way to solve this?
3. Is there a treeview component for access forms? You know, a terraced list where you can open and fold parent lines to cover/hide their child lines?

Thanks in advance!

 

[HiTechCoach]

1. Have you tried using the conditional formatting feature?

3. Yes, there is one. See Tree View Control