Displaying Records

[NewfieSarah]

I have 500 Records in my Software Table, and I would like to display only those records that match my criteria that I place in my text box on my form called Software Name. So Once I have entered the software type in my text box, then I would like to display those records at the bottom of the screen as the selected records.... Any ideas??My table is called, Software, which contains Software Type, Software Name, Serial Id, Comments, Inventory Number, Version , Key and Company... I have a text box that is called txtSoftware, Which searches the databse and display the information in a list box called, lstResult, I would like to however, have the option, display in the list box but also display those records on the bottom of my form as it will look like in design view of my table. I have no idea how to ever start the idea, Could someone help... I hope this is enough info. Thanks

 

[ssoltic]

On form "Software Name" put subform (continous view) based on query. In query create criteria to "look" at txtSoftware textbox on form. Create After update event of txtSoftware to requery the subform.

Hope this help.