Forms question

[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?

 

[Jeff Boyce]

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

 

[Hope]

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

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

 

[Jeff Boyce]

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