Combo Box Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query with a combo box, in the next field I would like it to
populate the value for the item chosen from the combo box. (Example Combo box
item is Late Fee- the next field should poplulate $5.00)
 
Dear Fluff:

Since you posted this to a query newsgroup, I assume you are having
difficulty with the query part of your question (not the part about adding a
column to the combo box).

Now, I have no idea from where the value of $5.00 comes. Is that in a
column in an existing table or query? Or does it need to be added up?

Let me know what is the source for this and I'll try to do what I can to
help.

Tom Ellison
 
Sorry that it has taken me so long to reply.

What I want the database to do is when I pick an item from the combo list
that it would then populate the correct dollar in the next field.

ex: if I pick "FINE" from the Combo box in my Description field - "$5.00"
would populate in the Amount Field
 
Dear Fluff:

Why not just use a combo box as the bound control for this column? You do
not have to Limit to List, so the user can use the list or ignore it as
desired.

Why get complicated when it isn't needed?

Tom Ellison
 
Back
Top