Re: [MS_AccessPros] create links in tab control

 

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@pbl.nl [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 (2)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___