table 1 < - form -> table 2

[omozali]

Hi all,

What is the easiest way to relink a single form to different tables

[PEB]

Yeah.. using multi tables... need more efforts! It's sure!

So you need VBA..

In On current event or where you need in the form module you type:

Me.Recorsource="Table1"

[nico5038]

It's strange to have one form template linking to multiple tables.
Normally you have different tables that have a unique set of fields.
When there are multiple tables with the same structure this often points to a not normalized database design. Like a tblOrdersJan, tblOrdersFeb, etc...

In such a case it's better to create one table and have the months as a selection to filter the "master table".

Can you elaborate why this is needed ?

Nic;o)

[omozali]

Because I need different users to be able to access their own tables using only one form. so instead of creating a form and a table for each user I thought it would be easier to have one form that links to different tables depending on the user

[nico5038]

Hmm, in such a case I would create one "master table" with an additional "username" field. When the users can have the same unique ID to the rows the it needs to be defined as part of the unique (composite) key.
Thus the selection can be by a simple filter that's applied when the form is opened.
This will also ease reporting "accross" multiple users...

Getting the idea ?

Nic;o)

[omozali]

Hmm, in such a case I would create one "master table" with an additional "username" field. When the users can have the same unique ID to the rows the it needs to be defined as part of the unique (composite) key.
Thus the selection can be by a simple filter that's applied when the form is opened.
This will also ease reporting "accross" multiple users...

Getting the idea ?

Nic;o)

Yes I do. I think maybe creating different tables would be easier to move them around (i.e. to different PC) if that user was for example needed to take his info with him on his laptop

[nico5038]

When a user needs a copy of his data you can still use one master table and a report (or e.g. an excel sheet) to export the data when needed.
When the user needs to maintain his data on the laptop then it's getting more complex and in general I code the data exchange myself, although Access does has a database replication function. You're however warned as this replication seizes to exist in Access 2007.

Does your user settle with a "read-only" copy of his data ?

Nic;o)

[NeoPa]

You may be flogging a dead horse here Nico.
We've (not just me) tried to get this concept across in other threads but there's no response as yet :(.