Hello folks-
I have a form below that is used to filter a table based on criteria in the text boxes.
The listbox is filtered based on a query "mainquery". I would like to add a subform or textboxes, not really sure which is appropriate, to show the contact info and address (last 2 columns in the listbox). The reason is that the listbox only shows one line and the contact and address row may contain multiple lines. Is there a way to link a subform to show the contact and address of the record that is highlighted/current record. Thanks for any help. Cheers! -Tom
I have a form below that is used to filter a table based on criteria in the text boxes.
The listbox is filtered based on a query "mainquery". I would like to add a subform or textboxes, not really sure which is appropriate, to show the contact info and address (last 2 columns in the listbox). The reason is that the listbox only shows one line and the contact and address row may contain multiple lines. Is there a way to link a subform to show the contact and address of the record that is highlighted/current record. Thanks for any help. Cheers! -Tom
