Tab Control Problem

I'm just wondering how I can add controls to tab control pages that
are bound to fields from different tables. I have 3 tables (road,
track and gym) with similar named fields and I want to create a tab
page for each table. Unfortunately, my tab control form only allows me
to view and set controls for one table. So even though I might have a
control bound to a field from table 'road', the information i enter
goes to the table 'track' because that is the default table for the
tab control form. My manual says I should be able to send and view
info from different tables using tab control but I can't seem to get
it to do so. Is the only solution to create a query that combines all
fields from each table??? Seems to defeat the purpose of a tab control
form then. Please help.

Patrick
.

Relevant Pages

  • Re: Change focus off tab controls
    ... I just tried it on a tab control form I have and it works just as I would ... HTH - RuralGuy acXP WinXP Pro ... Please post back to this forum so all may benefit. ...
    (microsoft.public.access.formscoding)
  • Re: Form Loading Time
    ... > It is a Tab Control Form so it does have quite a few ... I suppose you have some subforms on your pages. ... If you have subforms on your tab control load them dynamically: ... Private Sub PageControl_Change ...
    (microsoft.public.access.forms)
  • Re: two forms, same record
    ... great idea to use a form for your data entry/viewing ... Tables should never be used for this purpose anyway. ... If you put a Tab Control on your form, you will be able to put some ... Steve Schapel, Microsoft Access MVP ...
    (microsoft.public.access.macros)