Open Sunform in Tab Control

[JPR]

Hello,

I have created a database with a list of clients that have a unique SSN. Each SSN has 9 digits + a symbol (ex. 000-00-0000A, 000-00-0000B, 000-00-0000C, etc). I have then created a Menu Panel on which two different textboxes are used as query criterias to view all records in two different listboxes, depending if the search is done by Last name or SSN. I then click on the selected record in the listbox to open a form which display other information related to the selected record. This form has two TAB Controls.Obviously in this form there is the SSN field.

Page 1 of this form, displays the actual record select in from my listbox. TAB2 has a suform with its record source to the same table of TAB1, which I would like to display all other records, with the same SSN but different symbol. This will allow me to know in under the same SSN there are multiple records.



Thank you for your help.

[ranman256]

I would have 1 subform, and on the tab.change event
change the subform.sourceobject