ACCESS FEED: Re: [MS_AccessPros] create links in tab control

Kamis, 08 Oktober 2015

Re: [MS_AccessPros] create links in tab control

Hi Onno,

LinkMasterFields refers to a control not a field and does not have to be bound. You can do this in the mainform for LinkMasterFields to the other subforms:

Name: LinkMapID
Control Source: = subform1_controlname.form.MapID

LinkMapID can also be assigned via VBA from the mainform or any of the subforms. It does not have to be a calculated control

in subform1, on the current event:

'~~~~~~~~~~~~~~~~
with me.parent
     .LinkMapID.Requery
     .subform2.Requery
     .subform3.Requery
end with
'~~~~~~~~~~~~~~~~

warm regards,
crystal

Microsoft MVP Virtual Conference 2015 -- Access Web Apps, Bing Maps, linking to SQL Azure from Access desktop, Excel workbook, and SSMS (53 minutes)
https://channel9.msdn.com/events/MVP-Virtual-Conference/MVP-Virtual-Conference-Americas-2015/CONS2-Using-Access-and-SharePoint-for-Travel-Expenses-and-Pulling-up-Maps

~ have an awesome day ~

On 10/8/2015 7:40 AM, onno.knol@pbl.nl [MS_Access_Professionals] wrote:

Hi John,

A common table in all forms is the table map.

However some of the forms use map linked to some other table to show another perspective.

The main form therefore, can have map as recordsource, but the relevant info is in the subforms that are behind tab control. So, I wonder if this will help.

Some subforms show a list of maps, soe show details of just one map.

The idea is that you may select a record from a list and then have the contents of the other forms move to that same record.

Hope I am clear enough in my description ...

Onno

---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :

Onno-

Is there a Record Source in the outer form? If so, what is it? And what is the Record Source (SQL if queries) of the four subforms?

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On Oct 8, 2015, at 11:27 AM, onno.knol@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Dear Pro's

What is the best way to organize a set of coherent forms by means of a tab control.

I have a set of maps,

Each map has a file link in a table fileLink

A map has map records in a table Maprecords

The totals of these reocrds are in a table called Maptotals

I have a set of 4 forms; map list, (continuous) mapdetails, ( single) maptotals (single) and files ( continuous)

i want to order them in a main form with 4 tabcontrols,

BUT: when I am on a record in one form and I switch tabs,

I want the other tab to be on the same record.

How do I organise this with the least amount of programming?

Can I use parent- child link fields for subforms?

As I understand, these work in one direction, from parent to child,

but not the other way round.

What is the best design to choose?

kind regards,

Onno Knol