Can I use a combo-box to select the source for my form?

[keun]

I have a database which was getting so big that I put all the tables into individual .mdb files. Each mdb file had a table, a query, and a form.

Well, I got smart and brought all the forms (they are idenitcal) into one mdb and I just linked the tables.

So now, you have to open form1 to see tbl1 and form2 to see tbl2.

How can I just have one form, with a combobox on the top to select which table the data comes from?

 

[PHV]

You may change the value of the form's RecordSource property.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[fneily]

Could you explain what's in your tables? Their structures? Did you Normalize them? How are your relationships?
As for the database increasing in size, do you constantly delete and add data? Create or change queries? Have you tried a Compact and Repair?
Having a separate database file for related tables is sorta against the protocols of Access.

 

[mhartman1]

Hello

I believe you can do that by using the AfterUpdate event of your combobox to set your forms recordsource. Then just requery your form.

Regards
Mark

 

[keun]

The database was just big to begin with - 25,000,000 records and Access kept crashing. I split the tables up into individual mdb files. The tables only contain text, the fields are all identical.

 

[Remou]

It may be possible to have a union query joining the tables, but I have not tried with so many records.

 

[keun]

Well, I have 17 tables. So I just made the RecordSource be Table1 and then made 17 buttons which change the RecordSource to the other tables. And I put a big red text box at the top of the form to indicate to the user what they are looking at.

 

[fneily]

It seems that this is a moot point for you, but with 25 million records, I'm just curious, are your tables Normalized?

 

[keun]

By that question are you asking if I used the Table Analyzer to create realtionships?

We are not doing any entry in this thing. It is a ton of time-card records that we are looking at just to look for entries where the data-entry people found records to be illegible. Then I have hyperlinks to open the scanned TIF so people can verify that they are, in fact, illegible.

Do you think I should normalize the tables? I mean, there is room for relationships here, there are tons of repeat employee names, store locations, etc. But it is a really short-term need.