Hi there,

I would like to be able to add a "LIST" button on my form for inventory. When the user clicks "LIST" a form pops up and when the user selects an item, the original form reflects the record they chose. Right now I'm using a combo-box now but the user also has to be able to copy the record and because of the combo box, we are getting an Type Mismatch error. Is there a way to use a button to open the combo-box and achieve the same functionality without actually having the combo-box in the main form? Or would a sub-form be better? Can you make selections from a subform? Thanks.

Make sure that your 'selection' combo box is unbound and only used for selecting the records. Use a separate textbox to display the actual record. It also depends what you are trying to filter - generally speaking you filter on a main record eg Customer to show all related info such as orders in a subform.
Hope this is clear.