Tab Control form record source

[lpgagirl]

I have a tab control form with, 2 rows of 12 tabs. Each tab opens to reveal various on-call information for particular office locations throughout the province. Due to size limitations I have had to create 3 different tables to handle the form.

tblOnCallA-N
tblOnCallO-Z
tblOnCallSpecial

I cannot join the tables into a query due to size limitations + there is no common field. I thought that I could us the control source property for each field in the form to tell it where to get it's data for example,
=[tblOnCallA-N]![TorontoSec1]
=[tblOnCallA-N]![TorontoSec2]

1. I am getting the #Name? error
2. I also need to use the form for data entry. That is...if there is a change to who or what is on-call at a location, the user needs to make the changes in the form. The table needs to update with the new data.

Am I off base here? Is there a better way to achieve what I need?

Thanks,

Jeannie

http://thefloyds.50megs.com/index.html

 

[PHV]

Due to size limitations
Which limitations ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[lpgagirl]

The one that says you are only allowed 255 fields in a table/Query. All together I have about 360.

Jean

Jeannie

http://thefloyds.50megs.com/index.html

 

[PHV]

I have about 360
Have a look here:

http://r937.com/relational.html

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[lpgagirl]

PHV - point heard loud and clear.

My question to follow up is, how do I arrange it so that Access understands that each tab = a record? I now have one table with 15 fields + an autonumber field. The tab = the city or location. I have 24 tabs therefore the table should populate with 24 records.

Thanks again,



Jeannie

http://www.thefloyds.50megs.com