Search results

Thanks John, this was great!

Please see attached sample mdb. I like to have a form to show both showall and show selected queries. The idea is I select a portfolio by checking it on the showall query and the only selected records show on the right side query show selected. Thanks

Thanks for trying to help. However, I think may be I did not explain the problem right. Because of that, I do not think you understood the problem. It's my fault, Thanks anyhow.

You did not understand the question, I know that the first two tabs are from the same table, I even wrote that. I'm talking about the AccountDetails record from The ICGMASTER table and the Contact records from the contactview which is from seperate table Contacts. Thanks

The database is normalized, I just created the sample in a hury. Nevertheless, do you have an answer? Can I go to the same record that I selected in the first tab?

Here is a sample of the application. The idea is: The application opens on the “MasterView” choice from the toolbar which have AccountDetails tab and InvestmentDetail tabs. Suppose that within the first tab which is “AccountDetails” you selected the fund : “ADB” thru the dropdown list. Now if...