1 Form and 5 Tables associated. Is it possible?

[muras]

Hi everyone,
I´ve a Form and 5 tables.All the 5 tables have the same fields but different information.
Is there any possibility when I access the form to choose the table I want? I´ve tried to make a comboBox but it does not permit to scroll between tables,just one table with its information associated.
I also tried to make 5 buttons and choose the option'open form'and put it in the primary form, this way I have to make 5 new forms for the 5 tables,so when I click in one of the buttons it popup the associated form in a new window,this works but I would be really apreciated if someone could tell me if it is possible to have just 1 form and could choose the desired information from the any of the 5 tables in just one window

Thanks in advance guys

 

[PHV]

Why having 5 tables with the same fields ?
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

 

[muras]

Hi,
I know,but it is relly intended to have duplicated fields information.
Hope you guys can help

 

[SgtJarrow]

Even if you want 5 "like" tables, you can combine these into one. Just add one more column for the "table" and store the identifying name you want here. Then you can use one form, include a combobox and use tha to filter on just those records with a particular name from that identifying field.

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer

 

[TheAceMan1]

[blue] . . . it is relly intended to have duplicated fields information.[/blue]

Well . . . this is certainly not an access db, but if the fields have the same name & datatype you could simply change the [blue]RecordSource[/blue] of the form to the name of the proper table (or query thereof) . . .

By any chance are you trying to duplicate pages the way Excel does?

See Ya! . . . . . .

 

[ZmrAbdulla]

This can be done with some coding
see an example here

http://www.fontstuff.com/access/acctut12.htm

same thing can be done with popup form passing "OpenArgs" value.

mstrmage's idea also not bad but you should have a unique key to identify the records.

________________________________________________________
Zameer Abdulla
Help to find Missing people
Take the first step in faith. You don't have to see the whole staircase, just take the first step.
(Dr. Martin Luther King Jr.)