Using a form to open a form

[benu302000]

I'm new to this whole access thing, and don't know a whole lot about visual basic objects. I'm trying to put together a heirarchical form that starts with a list box full of rows of billets. I want to make it so that when you select a billet, and click a command button, it will launch a new form that draws on data related to what you selected in the list box in the first form. In this case it the new form would be drawing on a table of billet history. Any idea how I implement this? What object types and data members would allow for this? Thanks

 

[PHV]

Why not using a combo as the navigation tool ?
It is as simple as following the combo wizard.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[benu302000]

Ok, Now I have a combo box that selects values from my billet list. but I'm still unsure of how to go about opening a new form populated with related data. Any Help?