Forms question

  • Thread starter Thread starter Hope
  • Start date Start date
H

Hope

I am using a form to enter data where I have used a list of choices for one
of the fields. The choices are types of billing and I have a dollar amount
for each one. I would like to make a choice and have the dollar amount go to
the amount field automatically. Does anyone know how?
 
Why?

If you already have the type of billing associated with a dollar amount, why
do you feel you need to re-store that same dollar amount?

Why not just use a query that joins the table behind that form to the table
that lists the billing-type and dollar amount?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Jeff Boyce said:
Why?

If you already have the type of billing associated with a dollar amount, why
do you feel you need to re-store that same dollar amount?

Why not just use a query that joins the table behind that form to the table
that lists the billing-type and dollar amount?

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...

That's what i'm trying to do but it's not working
 
I'm confused.

Your original post said you wanted to store the dollar amount.

My response asked "why?", when you already know it (based on the
billing-type).

Which are you trying to do? What business need are you trying to solve?
What will having the dollar amount allow you to do?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top