Help with making macro !

[mwieting]

In my data I have a form called assets. These assets are customer's inventory of computers, router, access points, and servers. I want to keep track of any important information (i.e. user names passwords, and IP's). In my forum I have a hand full of "asset" types. What I want to do is this... If I select Router from my dropdown list of assets, I only want to display criteria from my router table. This router table contains Router Brand, model, IP address and user login info. If I select Windows Desktop from my dropdown I want to display the fields that are relavent to a desktop computer (user name, password, brand, etc).
Can someone help me?!?!

 

[Geotch]

Here's a picture of what I do with the drop down box.

Go to the query pane of the drop down:
1) create a 2nd column with all the data you want
2) after choosing the item on your form, display column 2 (which access calls column(1)) in a text box on your form.

Hope that helps.