Getting data from other forms/subforms

[iceboi714]

Hey guys,

I'm fairly new to Access so please be patient.
Im currently using 2003 and my problem is...currently I have 2 Forms and each with a subform. FormB has a textboxB that gets a sum of values from the subform-B(datasheet view).
Now, I am trying to call that value from textboxB to the subformA(datasheet view) of FormA.

I use this to call from subformA and it only works when FormB is open.

=[Forms]![FormB]![textboxB]

I want to have it so i dont' need both Forms to be open to see it.

Thanks

[MindBender77]

Hey guys,

I'm fairly new to Access so please be patient.
Im currently using 2003 and my problem is...currently I have 2 Forms and each with a subform. FormB has a textboxB that gets a sum of values from the subform-B(datasheet view).
Now, I am trying to call that value from textboxB to the subformA(datasheet view) of FormA.

I use this to call from subformA and it only works when FormB is open.

=[Forms]![FormB]![textboxB]

I want to have it so i dont' need both Forms to be open to see it.

Thanks

You could try appending the value of textboxB to a temp table then use "DLookup" in subformA to display the value. This way only one form needs to be open.

Bender

[iceboi714]

You could try appending the value of textboxB to a temp table then use "DLookup" in subformA to display the value. This way only one form needs to be open.

Bender

How would I go about appending values to a temp table?

[MindBender77]

How would I go about appending values to a temp table?

First create a table with only one column. Name the table something like data_temp. This is make it easier to identify the temp table. Next and assuming your subform is linked to a table, design an append query using the value of your textbox as criteria.

On the form that has the textbox, use the OnChange event or AfterUpdate event of the textbox to run the append query. This will populate the temp table.

Now you can use DLookup on formB instead of having both forms open at the same time. There are several different ways of doing what you asked.

Bender

[iceboi714]

First create a table with only one column. Name the table something like data_temp. This is make it easier to identify the temp table. Next and assuming your subform is linked to a table, design an append query using the value of your textbox as criteria.

On the form that has the textbox, use the OnChange event or AfterUpdate event of the textbox to run the append query. This will populate the temp table.

Now you can use DLookup on formB instead of having both forms open at the same time. There are several different ways of doing what you asked.

Bender

THANKS!! I'll give it a try and let you know how it goes.