Hi guys 
I need your help, plzzzzzzzzz. I want to return the item selected in a list box in MS access. The list box is returning a distinct list of States from my table of 1000+ records in access. Based on that list, I would like to produce a new form or a sub form within that form for the State selected in the list box. I'm pretty new to this and i've tried hard to figure this out for the past month and no luck. If anyone could help me out it would be greaaaaaaaaaaaaatly apreciated. HOw would i go about doing this? Would i have to create a query for each state so that when its selected i could produce the form off of the query? thanks in advance
I need your help, plzzzzzzzzz. I want to return the item selected in a list box in MS access. The list box is returning a distinct list of States from my table of 1000+ records in access. Based on that list, I would like to produce a new form or a sub form within that form for the State selected in the list box. I'm pretty new to this and i've tried hard to figure this out for the past month
and no luck. If anyone could help me out it would be greaaaaaaaaaaaaatly apreciated. HOw would i go about doing this? Would i have to create a query for each state so that when its selected i could produce the form off of the query? thanks in advance 