One text box = another

[mike02]

HEY!

How do I make on text box = another in a subform. So heres what i have. I have a Navigation form (2010 only) and i have two text boxes in the Form Header. CompanyName, and ManagementCompany. Now i have The management company bound to one table. but i have the ID number from that table (It is auto number), to insert it in other tables as a number instead of text. It is an adding data form. so icurrently have a drop down combo box which selects the management company which relates the ID. wokks great. IS there a way to make it automatically select the combo box, or text box if need be, to have it update automatically. Also With the Company Name how to i get that contents value correspond with others in the navigation form. (make that value in text box equla the value in the text box when i swith navigation buttons? eg...

__________________________________________________ ______Header______
Management Company_______________
Company Name_______________


__________________________________________________ __________Detail__
Button 1....Button 2....Button 3....Button 4....Button 5

[June7]

Is this form/subform arrangement? The master/child link will synchronize the related records. The ID will automatically save into the child record of the subform.

[mike02]

how do you use Child/Mast links? Ive never done anything like that.. thanks

[mike02]

June, i have attached a sample file.. when I type in Fund Name up in the header i want it to automatically update in the Invesment, Fund Strategy, Portfolio Manager, Supporting Doc., Risk Management, and Service Poviders. When i type The Management Company i want it to update Into Address Information. Is there a way to do this:S?Attachment 8431

[mike02]

June7,

I have been trying to run different code on update etc.

Ie.

me.[txtmc]=[forms]![Address Information].[form]![text0]

On the text box in the form i have tried changing its control source etc. I have been trying to link child and master fileds. Nothing has worked yet. thanks,

[June7]

Master/Child links are properties of the subform container control. I will try to look at your project in next couple days.

[mike02]

thanks, i will post any progress i have!

[mike02]

Still havent been able to get this to work, if anyone else has ideas, please share, thanks

[June7]

I've never built a navigation form in my projects. I find them somewhat confusing. Don't think I would use it for your situation. The subform containers on navigation form don't have Master/Child link properties. I would use a Tab control and put subforms on tab pages. The Master/Child link properties will synchronize the related records. The pk/fk will automatically save to the child record. No code required.

Review http://office.microsoft.com/en-us/ac...010098674.aspx

[mike02]

June7, I have the same form but instead of a navigation form i have used tabs with subforms like you have suggested. Now when Linking the Child/Master fields, I have been using the builder works, fne and i have everything linked etc. When I type the value in Master Field, How do i get it to appear in the child field:S Im still not seeing the data come up. Now i have all subforms, and my main for set to data, entry. Is there a way to have the subforms set up to equal the data entry in the Master form? It also wont allow me to enter data into the Two text boxes:S

[June7]

I would have to examine your form if you want to provide revised db.

[mike02]

Attachment 8553 Here is my Attachment

[June7]

What is purpose of the Add Fund form - to create/edit fund record and associate a company with that fund? What is the relationship of management companies and funds? I presume each company can have multiple funds but each fund can be associated with only one company?

Portfolio_Manager_Section table appears to be the primary table of funds. I would make this table the RecordSource of the main form and put it's bound controls directly on a page of the tab, not inside a subform. Then the master/child link properties of the other fund info subforms will synchronize on the fund pk/fk. The address info would not be a subform but a combobox to select company record to associate with the fund. If the company record does not already exist, entering it would be another issue. The NotInList event of combobox is one way to handle that.

[mike02]

the purpose is to stricly add information. Yes a company can be associated with many funds while one fund can only be associated with one company. I cant do that, sbecause you cant have tab controls insisde tab controls, and I use Tab controls in portfolio manager, so i wil lhave to use a subform, i was think, is there away to send it to the ast record when it is veiwed:S.

[mike02]

June 7, I currently worked it in so it works well. But still i have the same problem as before in that, Risk Management, Fund strategy, and Service Providers doesnt automatically update, Everything else does:S any ideas,

Thanks so much for you help with this, really appreciate it!