Multiple tables displayed in a single Form

[Guest]

I am trying to setup some data to display two tables within a single form,
and also allow me to edit both of those tables within that form, but it does
not seem to work.

The one table "Main Data" has all of the information that I am working on.
The Form was created from this main data.

The second table, "Time Span" is actually just a placeholder for some
numbers used in some expression calculations within the form on the main
data. In the form I orginally tried just putting these in as text boxes, but
when I close the database the numbers are not retained.

So what I did was create the table "Time Span" with 10 fields and one entry
for each field to corrrespond to the 10 calculations that I have within the
form. These numbers apply to the entire data set.

The problem however is that when I try to link to them in the form I get the
#number? error.

In the control source box for each form box I have tried the following

=[Time Span]![B1]

and

=[Tables]![Time Span]![B1]

Neither of which seem to work. Does anyone have any help on this?

 

[Steve]

What are the fields in Main data and Time Span?

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[John W. Vinson]

I am trying to setup some data to display two tables within a single form,
and also allow me to edit both of those tables within that form, but it does
not seem to work.

The one table "Main Data" has all of the information that I am working on.
The Form was created from this main data.

The second table, "Time Span" is actually just a placeholder for some
numbers used in some expression calculations within the form on the main
data. In the form I orginally tried just putting these in as text boxes, but
when I close the database the numbers are not retained.

What is the Recordsource of the form? Unless it includes the Time Span table,
you won't be able to reference fields in that table!

You can use DLookUp to retrieve the values from the table for your
calculations - but you can't just reference [Time Span]![fieldname].

John W. Vinson [MVP]