Building a subform list of records from search results

[CliffACS]

I want to find a way to do the following in my database. Similarly to building an invoice of items sold to a new customer as in the Northwinds mdb, I have a main form with subform whereby the user will build a list of records/items in the subform to make a group of items with quantities and costs. The user shall enter a name for this group of records on the main form and store this group in my groups table. Since my item list has thousands to select from, a combo box to find the item to select for the group would take way too long. Therefore, on the subform, I want to allow the user to click on a search button next to each empty line item (which opens up a separate search form that I've already created) and double click on the item name from the search form results so that it populates the line item on the subform. Has anyone created something like this? If so, please help.

 

[mithani]

Not sure whether this will help you.

This sql query will populate all records based on itemtype.

Me.ItemCode.RowSource = "SELECT Table.ItemCode, Table.description FROM table WHERE itemType = '" & Me.ItemType & "' ORDER BY Table.description;"

mithani