How do I make data from one form automatically go to another

[Guest]

Hello,
I created a database to manage my clients, thier authorization dates and
units of authorized service. When My employees submitt billing (Billing
form) it has client ID, date of service, units of service ect. I would like
the "units of service" that I imput in "billing"automatically go to the
"clients" form -and get totaled under "units of service". This will help me
keep a clear picture of the authorized units to ensure my employees don't
continue to service clients if they have no remaining units.

Thanks a bunch
Jessica

 

[Guest]

You could put a text box on your form with a control source that will do that:
DSum("[UnitsOfService]", "Your Table Name", "[Client] = '" &
Forms!MyFormName!txtClient & "'")

You will have to replace my made up names with your real names. You can't
use Me. in a control source, so you will have to style it as I have above and
substitute your form's name. Also, the above code assumes the Client field
in your table is text. If it is a number, remove the single qoutes around it.

 

[Guest]

I am still having a hard time with this. I am a new user. I would like the
text box in "BA Authorization subform" called "services recieved" to show the
sum of "units of service" for each client in "the billing form". My
employees have several clients. When I imput the units of service they are
billiing for with each client using thier client ID. I would like access to
take that Client ID and those units from billing and total them all in
"services recieved" in BA authorization subform.

I greatly appreciate all your help. Please respond clearer in like an
"Access for Dummies" manner.

Jessica

You could put a text box on your form with a control source that will do that:
DSum("[UnitsOfService]", "Your Table Name", "[Client] = '" &
Forms!MyFormName!txtClient & "'")

You will have to replace my made up names with your real names. You can't
use Me. in a control source, so you will have to style it as I have above and
substitute your form's name. Also, the above code assumes the Client field
in your table is text. If it is a number, remove the single qoutes around it.

Hello,
I created a database to manage my clients, thier authorization dates and
units of authorized service. When My employees submitt billing (Billing
form) it has client ID, date of service, units of service ect. I would like
the "units of service" that I imput in "billing"automatically go to the
"clients" form -and get totaled under "units of service". This will help me
keep a clear picture of the authorized units to ensure my employees don't
continue to service clients if they have no remaining units.

Thanks a bunch
Jessica

 

[Guest]

Is this sub form a datasheet or a continuous form?
Is my understanding that there will be one employee on the maing form and
one or more clients on the sub form?
What is the name of the form and the text box the employee id is on?
What is the name of the table where you want to get the client id?
what is the name of the field in that table that has the client id?
What is the name of the field in that table that has the employee id?
What is the name of the form?
What is the name of the sub form?

Be happy to help, but to give you detail, I need specifics.

I am still having a hard time with this. I am a new user. I would like the
text box in "BA Authorization subform" called "services recieved" to show the
sum of "units of service" for each client in "the billing form". My
employees have several clients. When I imput the units of service they are
billiing for with each client using thier client ID. I would like access to
take that Client ID and those units from billing and total them all in
"services recieved" in BA authorization subform.

I greatly appreciate all your help. Please respond clearer in like an
"Access for Dummies" manner.

Jessica

You could put a text box on your form with a control source that will do that:
DSum("[UnitsOfService]", "Your Table Name", "[Client] = '" &
Forms!MyFormName!txtClient & "'")

You will have to replace my made up names with your real names. You can't
use Me. in a control source, so you will have to style it as I have above and
substitute your form's name. Also, the above code assumes the Client field
in your table is text. If it is a number, remove the single qoutes around it.

Hello,
I created a database to manage my clients, thier authorization dates and
units of authorized service. When My employees submitt billing (Billing
form) it has client ID, date of service, units of service ect. I would like
the "units of service" that I imput in "billing"automatically go to the
"clients" form -and get totaled under "units of service". This will help me
keep a clear picture of the authorized units to ensure my employees don't
continue to service clients if they have no remaining units.

Thanks a bunch
Jessica