How do I create a nested (?) drop-down list control in a form? 1

[tspencer]

I'm using a form to capture maintenance activity on equipment located in different rooms. There are many pieces of equipment in each room, listed in a single data table as the "Location" and "Equipment" fields. I want the user to use a drop-down list, select the "Location" criteria, which would then filter and show the "Equipment" choices (a nested list?). I want to capture both the "Location" and "Equipment" values for the record. Any advise on how to do this, or accomplish the same thing another way?

Tom Spencer
tomaskmbl@aol.com

 

[mrichards]

One thing can you do is do have a form with a couple of drop down boxes. One drop down box would have the room numbers in it. The next box "items in the room" would have have a query build on the results of the box for the room.
"where room = [me.room]"
When the box is updated for the room # the have the form refresh it's self. this would update the item box.

Mark

 

[ronrsr]

How do you force the form to refresh?

-rsr-

 

[tspencer]

Thanks, Mark. I had already done what you suggested, except for the refresh form. That should be the magic bullet.

Tom

Tom Spencer
tomaskmbl@aol.com

 

[mrichards]

in the events -> afterupdate -> code builder ->

Me.Refresh

Mark