Open multiple Tabs at the same record

[SYMEX]

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 you click on the “InvestmentDetails” tab the record is the same “ADB” because it’s the same table “ICGMASTER”. However when you select “ContactsView” from the toolbar which opens on the “Contact Records” tab, we have to us the drop down list to have it open to “ADB” record or press the button GoToMarkedRecord button which the user does not want it. The user wants the record to open at the same fund “ADB”. Obviously after that every time the user select a fund in the AccountDetails screen the same fund appears in the ContactsRecords screen.
Is there a trick to do that?
Thanks
Symex

 

[boblarson]

I hate to tell you this but you really need to learn how to normalize a database before continuing. If you continue on this path it will only cause you great pain and suffering when trying to accomplish what you are wanting to accomplish.

Read this: http://support.microsoft.com/kb/283878

Also, your form has the same fields from the same table on two different tabs, which isn't good. You really should only have a field on there one time. In this case you really need to use subforms.

 

[SYMEX]

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?

 

[boblarson]

Okay, let's go over this and I'm not trying to be difficult but you asked about this stuff so you will get frank answers.

1. The sample is not normalized, so I had to assume that your database is not as well. If you want better feedback then post the real thing (minus data is fine) but to post a sample which is not at all like your database is not going to help. If it is like your database then it has serious problems.

2. The way you currently have it set up, your Account Details and Investment Details are all the same record anyway so there is nothing to do as they are the same record. Just because the controls are on a tab control does not change that fact. If you are going to work with different recordsources (which they should be anyway because Account details and Investment details should not be going to the same table as that is not normalized.

3. I hope you don't have the fields in the table ICGMaster, because repeating fields (ICGtBackup1Name, ICGtBackup2Name) is not normalized.

So, anyway the way you have it right now the record you selected on the first tab is the same record on the second tab because the form's recordset is all the same.

 

[SYMEX]

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

 

[boblarson]

If you set a text box on the contacts main form to the [FundAcronymn] and then make sure that all three subforms are linked to it via the Master / Child links, you can use this in the WHERE clause of the macro:

[FundAcronymn]=[Forms]![MasterView]![Text125]

 

[SYMEX]

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.

 

[boblarson]

Your question:

Now if you click on the “InvestmentDetails” tab the record is the same “ADB” because it’s the same table “ICGMASTER”. However when you select “ContactsView” from the toolbar which opens on the “Contact Records” tab, we have to us the drop down list to have it open to “ADB” record or press the button GoToMarkedRecord button which the user does not want it. The user wants the record to open at the same fund “ADB”.

My Answer was exactly what would allow you to go to the contacts records tab and already have ADB selected for you. Your forms are not linked properly and it has to do with how you are opening them and how you have subforms linked.

 

[Banana]

I took a look at your sample.

As Bob said, if this is based on same model as your real database, then it's not normalized. I did not see any relationships defined as well.

It also looks like you are opening three forms separately. Not only that mean I have three windows on my taskbar (which would seriously annoy my users. Your users may not mind, though), but also that means you are responsible for maintaining links yourself.

That said, I couldn't test it because the sample had no data in it so I am not really sure how they all work together. Maybe if you made up some bogus data in the sample, it'd help show the problem because you want to ensure that all forms point to same selected records, but there are no records to select.

HTH.