Re: [MS_AccessPros] create links in tab control

 

Onno-

No, not clear.  Are you saying that all four forms have the table as the Record Source?  If that's the case, then I need to know the structure of the table.

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 3:40 PM, onno.knol@pbl.nl [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> 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

__._,_.___

---

Posted by: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (4)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___