Linking Multiple Tables to Multiple Controls

[Anthony Law]

I'm sure someone out there has done this but if not here's
my problem. I have created a database with 12 tables. I
have also created a form so that the data can be
displayed. I have several text and combo box controls on
my form; each control needs to be linked to a specific
field from a specific table. I have tried several
different approaches but nothing has worked. Any
ideas/suggestions?

 

[Bas Cost Budde]

I'm sure someone out there has done this but if not here's
my problem. I have created a database with 12 tables. I
have also created a form so that the data can be
displayed. I have several text and combo box controls on
my form; each control needs to be linked to a specific
field from a specific table. I have tried several
different approaches but nothing has worked. Any
ideas/suggestions?

You don't have 12 tables because there are 12 months, now do you? If
yes, change your design by adding a month field to one table and move
all data there.

This having said... if you just need to display the data, you can use
DLookup functions for the controlsources of the controls.

If you need to *edit* all data, however... that is complicated. What is
the meaning of this form?