forms

[Jevon]

I have an "x" form and a "z" form that data is entered into.
I want to use some of the data for calculations from the x form in the z form
I need it to be displayed prior to these calculations.
the data is relevant for these calculations based on the date entered in the
forms.
There is a date box on the form.
their my be more then one entry that needs to be calculated per date

Any thoughts?

 

[John W. Vinson]

I have an "x" form and a "z" form that data is entered into.
I want to use some of the data for calculations from the x form in the z form
I need it to be displayed prior to these calculations.
the data is relevant for these calculations based on the date entered in the
forms.
There is a date box on the form.
their my be more then one entry that needs to be calculated per date

Any thoughts?

Forms don't store data. Tables do. What are the Recordsources of these forms?
Where is the information being stored? What is the nature of the calculations?

You can use an expression like

[Forms]![NameOfForm]![NameOfControl]

in an expression on some other form, provided the form you're referencing is
open.

 

[Jevon]

John
The two forms (X and Z) are used to calculate but more specifically balance
reported sales and cash collected by employees at my retail store
the x is run 1 to 5 times a day the z is run at the end of day.
I want to add a box called Cash Collected from any of the x forms that
coincide with the z form specifically on the same day
the Cash Counted is by separete employees and needs to be added to z form
for balancing
The Z form record source is the Z table and X form is X table
The Z table data will be used for additional reports, projections for the
store
The X table data will be used for additional reports, projections for
employees
My guess is (yes please tell me if im wrong) is that the all forms used by
employees will be open so they can enter data, unless I can make shortcuts to
open them when have employees log in

--
Jevon

I have an "x" form and a "z" form that data is entered into.
I want to use some of the data for calculations from the x form in the z form
I need it to be displayed prior to these calculations.
the data is relevant for these calculations based on the date entered in the
forms.
There is a date box on the form.
their my be more then one entry that needs to be calculated per date

Any thoughts?

Forms don't store data. Tables do. What are the Recordsources of these forms?
Where is the information being stored? What is the nature of the calculations?

You can use an expression like

[Forms]![NameOfForm]![NameOfControl]

in an expression on some other form, provided the form you're referencing is
open.

 

[John W. Vinson]

John
The two forms (X and Z) are used to calculate but more specifically balance
reported sales and cash collected by employees at my retail store
the x is run 1 to 5 times a day the z is run at the end of day.

Forms can't be "run". They're windows which display data. You can OPEN a form,
which runs its recordsource query; a form may contain macros or code which can
be run on some appropriate form event - but a form doesn't "run".

I want to add a box called Cash Collected from any of the x forms that
coincide with the z form specifically on the same day

Again: There aren't multiple x "forms". There is one x form. It may or may not
be open; the data in its recordsource table is there, whether the x form is
open or not.

the Cash Counted is by separete employees and needs to be added to z form
for balancing

Then the Cash Counted value needs to be stored in some field in some table.

The Z form record source is the Z table and X form is X table
The Z table data will be used for additional reports, projections for the
store
The X table data will be used for additional reports, projections for
employees
My guess is (yes please tell me if im wrong) is that the all forms used by
employees will be open so they can enter data, unless I can make shortcuts to
open them when have employees log in

It really sounds like you're designing the database with the forms first.
That's the wrong way around! Tables are PRIMARY; you need a good, normalized
table design in place before you even start *thinking* about forms. Do you? If
so, how are your tables structured and related?

Your calculations should NOT depend on what other forms happen to be open.
They should instead go to where the data resides... the tables.